Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I just watched the Power BI training video on grouping and binning, and saw exactly what I want to do, but grouping works a little differently if you only group a single category. The pie chart below reports sales by country. I want the chart to display USA, and everything else as Other. It does change the slice colors to all grey, but it keeps the slice lines and country names. It should be a single slice called "Other". It behaves correctly if there are two or more members of the group. Is there a way other than grouping to group?
Thank you,
MIke Grammas
Solved! Go to Solution.
Hi mgrammas,
When you add field in legend, it will show like that
When you delete it , it will show like below
This is by design
You also could design chart like below
When you click “do to next level”, it will show like below
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi mgrammas,
When you add field in legend, it will show like that
When you delete it , it will show like below
This is by design
You also could design chart like below
When you click “do to next level”, it will show like below
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dax,
That worked for me, but it isn't obvious to me why it works. That's okay, it will hit me some day. I am just beginning my Power BI journey.
Mike
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |