Forum Discussion

pawelj795's avatar
pawelj795
Post Prodigy
6 years ago

Pie chart - filter Table

Hi, I have Pie chart and table as below. I want to filter my table by every piece of pie chart. My problem is that pie chart contains only measures -> that cannot be change. I think t...
Need Help
Tips and Tricks
Tutorial Requests
Icey's avatar
Icey
Community Support
6 years ago

Hi pawelj795 ,

You can use the DAX expression below to convert several measures to one.

1. Enter a AgeRange table without any relationship among other tables.

2. Create a measure.

Measure =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'AgeRange'[AgeRange] ) = "0-15", [0-15],
    SELECTEDVALUE ( 'AgeRange'[AgeRange] ) = "16-30", [16-30],
    SELECTEDVALUE ( 'AgeRange'[AgeRange] ) = "31-60", [31-60],
    SELECTEDVALUE ( 'AgeRange'[AgeRange] ) = "61-120", [61-120],
    SELECTEDVALUE ( 'AgeRange'[AgeRange] ) = "120+", [120+]
)

3. Put 'AgeRange'[AgeRange] on Legend and [Measure] on Values of chart.

 

Hope this could help you. If it doesn't work, please share me a dummy PBIX file without real data or sensitive information. And tell me your requirements.

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.