Forum Discussion
Power ParticipantDynamic Pie Chart "Values" based on Radio Button Selection
Hi StuartSmith ,
So you wanna get a result such as below?
If so,go to query editor>select column "city">"unpivot columns">"unpivot other columns",and you will get a new table as below:
Then back to report view,create a measure as below:
Measure = CALCULATE(COUNT('Table'[City]),FILTER('Table','Table'[Value]="Yes"))See attached for the related .pbix file.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Power ParticipantPragati11 sample data would simply be...
City | 5G Available | eSIM | VoLTE | VoWiFi |
| London | Yes | No | Yes | Yes |
| New York | Yes | Yes | Yes | Yes |
| Paris | Yes | No | No | No |
| Madrid | No | Yes | Yes | No |
Then would like a pie chart with "City" for the pie chart "Legend" field, leaving the pie chart "Values" field empty and populated by whatever was selected from the selection of radio buttons or check boxes with "5G Available", "eSIM", "VoLTE" and "VoWiFi". So if the user select "5G" the chart would show 5G data for each city, and if "eSim" was selected it would show "eSim" data.
Hope that makes sense.
Community SupportHi StuartSmith ,
So you wanna get a result such as below?
If so,go to query editor>select column "city">"unpivot columns">"unpivot other columns",and you will get a new table as below:
Then back to report view,create a measure as below:
Measure = CALCULATE(COUNT('Table'[City]),FILTER('Table','Table'[Value]="Yes"))
See attached for the related .pbix file.
Best Regards,
Kelly