Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Reg: Display columns based on slicer selection


I have created 5 different measures and i have used those in table.Now i want to display those 5 measures in table based on slicer selection.How to achieve this.please help.

for example: if i select measure 1 then only that particular should should display in table.


Hi Amit thanks for the reply,

i have created 4 measures and i have displayed in table/matrix.Now i want to display these measure values based on selection.
for ex: i have created 1)Actual MTD -----data is coming from actual table
2)Plan MTD -----data is coming from Plan table
3)Prior MTD -----data is coming from Actual table
4)Projection MTD---data is coming from Projection table
Now i have placed all these 4 measures in table/matrix.I need to create a slicer based on Actual,Plan,Prior,Projection.
Now if i select Actual then actual column should display and if i select Actual and Plan then both column should display etc.
How to achieve this.

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.


Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.