Forum Discussion
PowerBI 'If' function
Hi all, I'm trying to a build a PowerBI dashboard that looks two identical but reports for two products (cannot be combined) using the same visuals. E.g. - a bar graph and line that looks at ...
You can use SELECTEDVALUE Function to make the Slicer/Check box value get invoked.
Selection = SELECTEDVALUE(Table[Column])
Based on this You can create Report and Create Slicer showing the Product A and Product B
The moment you Select Product A , you will see the report which shows only the result of Product A and vice a Versa
Try and let me know
VijayP
Community Champion
Community ChampionYou can use SELECTEDVALUE Function to make the Slicer/Check box value get invoked.
Selection = SELECTEDVALUE(Table[Column])
Based on this You can create Report and Create Slicer showing the Product A and Product B
The moment you Select Product A , you will see the report which shows only the result of Product A and vice a Versa
Try and let me know
Yes, that's the function I was looking for thank you!