Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 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.
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.
All help is appreciated.
Thank you!
Solved! Go to Solution.
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
Proud to be a Super User!
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
Proud to be a Super User!
Yes, that's the function I was looking for thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |