Forum Discussion
Create a slicer for columns
Hi!
I am trying to create a slicer that would let me select the measures shown in a bar chart.
I have created a dissconected table that I will use to select the columns that I want to show:
The problem that i have is that power bi doesn't let select the column:
Thank you very much
There are @carlosmeep ,
In powerbi, we couldn't use the dynamic column in visual, we could just change measures. Therefore, you must create measures for each slicer option, and then use the switch function to create a measure that lists all the slicer measures.
If you want to use the dynamic column, I think you need to follow amitchandak\'s suggestion, and use bookmark to achieve this goal.
Saludos
Zoe ZhiIf this post helps, then please consider Accepting it as the solution to help other members find it more quickly.
4 Replies
Thanks amitchandak ,
That would word, but power bi won't accept it. It won't allowed the construcction, doesn´t recognise the column name as a valid input (
in the answer you proposed the error would be (highlighted):
- amitchandak
Super User
You will be able to select measures. For column, switch try with bookmark
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
