Forum Discussion
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 will show only fullname and complete coloum.
the result must be like this ( it just example i just remove the incomplete coloum)
i have try use the edit interaction and it still useless
thank you :)
BR,
Faishal
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
2 Replies
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
Dear JosefPrakljacic ,
Thank you so much JosefPrakljacic , The problem has been solved.
have a nice day!,
BR
faishal