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 that bookmarks can be workaround, but I don't know exactly how(I create buttons provisionally)

Alternatively, maybe other visuals can be helpful?

Need Help
Tips and Tricks
Tutorial Requests

21 Replies

  • rajulshah's avatar
    rajulshah
    Resident Rockstar
    6 years ago

    Hello pawelj795,

    You can create a calculated column with the values of your Aging Buckets and create the measure accordingly.
    If you can provide the sample data, I can help you in a better way.

    • pawelj795's avatar
      pawelj795
      Post Prodigy
      6 years ago

      rajulshah 
      It's a bit complicated, but I cannot create columns, it must be only measures.
      I think bookmarks could be only solution, but I dont know how to creative create them, that they would fit with pie chart.
      (every bookmark are different table with same column of index number and one measure of aging)


      In meantime, I try to provide you some sample data.

      • Tahreem24's avatar
        Tahreem24
        Super User
        6 years ago

        pawelj795 ,

         

        What I understood from your scenario is that You want something like Drill down Pie chart? Means If you click on any bucket lets say 0-15 so corresponding data will get populated? Let me know if I sensed something wrong.

         

        If Above said is your requirement so I suggest you to use Custom Visuals like "Advanced Donut Visual" from Market Place.

         

        Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!

  • 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.