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.
Hello. I have three tables with data (Fig1). I summarize the data from each table to plot. The question is, how do I make a cut on the tables? So that when you select 1 from the tables, only the data is shown on the slice.
Solved! Go to Solution.
Hi @skitovich,
you can append the three tables into one table that carries the original table names as a column.
Then you can filter the table using this "table name" column.
Hi,
i add a custom column with the table name to each table.
Select "Append Queries as new"
Select the relevant queries
Disable the load on the appended queries.
Hi @skitovich ,
I don't quite understand your requirements . Do you want to filter the data in these three fact tables ? And slicer needs to display the corresponding range value when you select a summary value of the three tables ? If it is in this case, then it is impossible... Slicer can't interact with other visuals and it also can't be filtered.
If my understanding is not correct, please provide more details (including some sample data from these three tables and the results you expect ) . Thank you.
Best Regards
Rena
I wanted the table names to be displayed in the slicer, and when one of the tables was selected, the data was displayed. If this is not possible, then I will choose your solution as the right one.
Hi @skitovich,
you can append the three tables into one table that carries the original table names as a column.
Then you can filter the table using this "table name" column.
Hi,
i add a custom column with the table name to each table.
Select "Append Queries as new"
Select the relevant queries
Disable the load on the appended queries.
Hi @skitovich ,
I think you need dimension tables that filter your 3 fact tables.
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |