Create a slicer for columns

[carlosmeep]

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

[amitchandak]

@carlosmeep 

Refer :https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

[carlosmeep]

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):

[dax · Accepted solution]

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 Zhi

If this post helps, then please consider Accepting it as the solution to help other members find it more quickly.

[amitchandak]

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