PowerBI 'If' function

Question

Hi all,&nbsp;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.&nbsp;E.g. - a bar graph and line that looks at sales in different regions. However you'd have to select 'product A/product B' and this would then be applied to all subsequent visuals on different pages. I'd need the data source in the graph to change depending on the selected product.&nbsp;In excel I would have done an if function that would tell excel which tab to pull the data from depending on the category selected. I'm struggling to work out the equivalent function in PowerBI.&nbsp;&nbsp;All help is appreciated.&nbsp;Thank you!&nbsp;&nbsp;

vijayp · Accepted Answer

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

Forum Discussion

PowerBI 'If' function

2 Replies

Related content

If Function in PowerBI Query Editor

PowerBI measure IF statement

Switch or If Function

IF Function - 2 Conditions,

PowerBI Copilot Functional Scope