Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ShreyasSB12
Frequent Visitor

Dynamically change the table based on slicer selection.

Hi Team,

 

I have 2 Tables(Profit and Loss)which has same set of columns.
I have a slicer which has option to select : 1)Profit
2)Loss
If profit is selected in the slicer.
All my visuals should get the fields from Table : Profit

If Loss is selected in the slicer.
All my visuals should get the fields from Table : Loss.

Any idea or any link how can i go.
Thanks in advance !

 

4 REPLIES 4
PaulDBrown
Community Champion
Community Champion

You can create a separate table for the slicer using:

Metric = {"Profit", "Loss"}

Then create a measure along the lines of:

metric measure = IF(SELECTEDVALUE(Metric[Value]) = "Profit", [Sum Profit], [Sum loss])

 

where the sums follow this pattern:

Sum Profit = CALCULATE (SUM(Table[Value]), FILTER(Table, Table[Type] = "Profit"))

where 'Table' is the fact table and 'Table'[Type] is the field which establishes the type for the values.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Thanks for the reply.

Here i am not looking for sum and filter the column.

I am trying to select the Table based on the value selected in slicer.

i have more number of pages and many visuals across all pages.

All visuals and pages should point to the table based on slicer selection.

AbbasG
Memorable Member
Memorable Member

@ShreyasSB12 Hi, one way of achieving this is through bookmarks. Please refer to the below pbix file.
Hope it helps.
PBIX 

Thanks for the reply.

Yes bookmark will work.

But i have more number of pages and many visuals across all pages.

So book mark will be tough to handle.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors