use slicer to change between 2 tables with 1 chart

[Naseebah-RJH]

Hello dears..

I have 2 defferint tables with same colume that means - i have 5 citys and deiffernt value- (1 st table i have AVG , 2nd MEAN).

So,i want to present this tables on 1 chart 1 slicer with(AVG,MEAN).

Is it possible ?or if u have any easy idea?

 Thanks .

[v-lionel-msft · Accepted solution]

Hi @Naseebah-RJH ,

Maybe you can do like this. Please refer to my .pbix file.

let
    Source = Table.NestedJoin(#"Table 1", {"City"}, #"Table 2", {"City"}, "Table 2", JoinKind.Inner),
    #"Expanded Table 2" = Table.ExpandTableColumn(Source, "Table 2", {"City", "Mean"}, {"Table 2.City", "Table 2.Mean"}),
    #"Removed Columns" = Table.RemoveColumns(#"Expanded Table 2",{"Table 2.City"}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Removed Columns", {"City"}, "Attribute", "Value"),
    #"Sorted Rows" = Table.Sort(#"Unpivoted Columns",{{"Attribute", Order.Ascending}})
in
    #"Sorted Rows"

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Naseebah-RJH , Not very clear. You need to have a common dimension city between these two tables. using that you can plot both of them together https://youtu.be/Bkf35Roman8

[Naseebah-RJH]

Thank u

My idea i want=> 1 chart with +1 slicer (to navigate between AVG & MEAN) for same cities

                      =>this chart in first time present to me AVG valuse for 5 city.

                      =>then i can change chart from slicer  to present MEAN value for same 5 city.

*I make 2 tables 1 for AVG another for MEAN

 I already make 1 chart for MEAN present 3 quarters Value for each city is it possible to make slicer here to change values to be AVG values.

Hope it is clear!

Thank u again.