Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a KPI Measure that I would like to create a sliceable pi chart from. I have a sample file, but essentially I want the pi chart to show the number of Reds, Yellows and Greens in reference to the KPI Indicator, and I want to be able to click on the Reds to see only those projects.
@enswitzer , in the pie chart you can not use conditional formatting. You can create it on the measure, but in the case, you created it with more than one measure and no legend, you can drill/filter .
For such case, you might have to try binning - https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |