Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 !
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.
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.
@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.