Create Pie Chart for Two Columns/Measures with same data type

Akhil

I have 2 columns in my data with  same data type.

 

The table looks like:

Date	Web Registration	App Registrations
Jan-19	10	95
Feb-19	14	72
Mar-19	15	67
Apr-19	10	89
May-19	15	95

 

I want to create a pie chart showing the sum of the Web logins and sum of app logins.

How can the two columns/dimensions and related numbers be brought onto the same pie chart.

 

I went through the related question but the pivot and sql method did not help.

 

Any insights would be helpful.

Godiepi

Hi @Akhil 

 

you can easily create an ETL dataflow using the "Collapse Columns" option setting up up as shown in the picture below to create a new Dataset that allows you to create that Pie chart you are describing

 

Akhil

Thank you @Godiepi 

That worked like a charm !!!