Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Pie Chart Filter

Help,   My project want to make filter use the pie chart, so when user click value in pie chart it will change the table . exampe: when user click complete value in pie chart and then the table ...
Need Help
  • JosefPrakljacic's avatar
    JosefPrakljacic
    6 years ago

    Hello faishalab,

     

    you need to unpivot your Complete/Incomplete columns in the Power Query Editor.

    You see aScreenGif below how to get it done (sry for the German PBI Desktop version but you will get my point :-) )

     

    If this post was helpful please mark it as solution & kudo it.

     

    Have a nice day faishalab!

     

    BR,

    Josef 

     

JosefPrakljacic's avatar
JosefPrakljacic
Solution Sage
6 years ago

Hello faishalab,

 

you need to unpivot your Complete/Incomplete columns in the Power Query Editor.

You see aScreenGif below how to get it done (sry for the German PBI Desktop version but you will get my point :-) )

 

If this post was helpful please mark it as solution & kudo it.

 

Have a nice day faishalab!

 

BR,

Josef 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Dear JosefPrakljacic ,

     

    Thank you so much JosefPrakljacic , The problem has been solved.

     

    have a nice day!,

     

    BR
    faishal