The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am currently trying to create a report in PowerBI where there user can select a table (via a Silcer), and then depending on their choice it will show a different set of results in a visualisation.
For example, they click one of the below:
And then a visualisation will change to now be looking at that table. The fields the visualisation will be looking at have the same name in each table, but the overall table schema is different.
Now sure if anyone had any ideas on how to achieve this.
This is possible in Power BI but little tricky. Please refer to below link. It will give you idea on how to build what you are looking for.
http://sqljason.com/2012/11/measure-selection-using-slicers-in.html