Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
After applying filter in the data I need to count how many are H/M/L (L <5,M<8,H>8) and based on the count need to plot a pie.
Please help.
Solved! Go to Solution.
hi @Sriku
If [H/M/L] is a calculate column or calculate measure?
If it is a calculate column, you could just drag [H/M/L] column into legend of a pie chart and then drag [Count of H/M/L]in Value and set aggregate type is Count.
If it is a calculate measure, you need a separate table that contains 'Low' 'Medium' 'High',
then create a measure like below logic
Measure 3 = var _table=FILTER(CROSSJOIN(ADDCOLUMNS('Fact',"_type",[Measure]),'Type'),[_type]=[Type]) return
COUNTROWS(_table)
here is a same post i have solved, you could refer to it
https://community.powerbi.com/t5/Desktop/Use-measure-as-chart-legend/m-p/1237315#M547738
Regards,
Lin
hi @Sriku
If [H/M/L] is a calculate column or calculate measure?
If it is a calculate column, you could just drag [H/M/L] column into legend of a pie chart and then drag [Count of H/M/L]in Value and set aggregate type is Count.
If it is a calculate measure, you need a separate table that contains 'Low' 'Medium' 'High',
then create a measure like below logic
Measure 3 = var _table=FILTER(CROSSJOIN(ADDCOLUMNS('Fact',"_type",[Measure]),'Type'),[_type]=[Type]) return
COUNTROWS(_table)
here is a same post i have solved, you could refer to it
https://community.powerbi.com/t5/Desktop/Use-measure-as-chart-legend/m-p/1237315#M547738
Regards,
Lin
@Sriku , You need to try segmentation/ binning
https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-po...
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |