Help with slicer

[skitovich]

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.

[mwegener · Accepted 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.

[Anonymous]

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

[skitovich]

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.

[mwegener · Accepted 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.

[mwegener · Accepted solution]

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.

[mwegener]

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