Utilizing a slicer to reduce number of columns

[Cezar]

Good afternoon

I am relatively new to Power Bi and still have lots to learn and I have a question regarding tables such as these ones.

Is there a way to add a slicer of a filter of sorts that when I filter by "Draft" only the "Draft % Comp" and the "Draft Forecast Date" remain effectively hiding the "Interim % Complete" and "Interim Forecast Date".

While doing some research I saw unpivoting the columns is generally the accepted solution, however that does not work here as it messes up the table:

Thank you for your help

Regards

Cezar

[v-stephen-msft · Accepted solution]

Hi @Cezar ,

We often create a option table for the slicer(entering data).

Then create a measure to switch.

Measure = SWITCH(SELECTEDVALUE('Table (2)'[Option]),"option 1",[Measure1],"option 2",[Measure2])

Hope to help you.

Best Regards,

Stephen Tao

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

[Cezar]

@amitchandak 

Each column has the following function initially 

and after unpivoting

[amitchandak]

@Cezar , click on those errors and share