Forum Discussion
Solved
Pir to switch or toggle between Type and Sub-type
Hi, I am trying to getr a pie chart to switch or toggle. When a user selects one "Type" in a slicer, the pie should show "Sub-type". When they select "ALL", the pie should show "Type". The rea...
DavidWaters100 you should use bookmarks to achieve this
https://www.youtube.com/watch?v=_Afcj8mT5_Q
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
DavidWaters100you can achieve the desired result by using unpivot feature in power query window. In this way, you will have 3 columns one column which has numeric value, second column which will have main or sub-filter value, and 3rd column which will have all filter values. Below is the screenshot for your reference.