Select different Tables for same Visual based on Slicer Selected value

[ShreyasB]

Hi all,

I am planning to change\Select the tables based on the value selected from slicer.

I have 4 tables as below :

                

I have a slicer and one visual as below

Slicer value is coming from Calendar-month

Month and value fields i have dragged from January Month.

But what i am looking is,when i select February,the fields should come from February table.Now its coming as empty as below:

I tried creating relatinship as below but no luck:

Appending the table or Bookmarks will fix for me,but i am looking for something else i have around 1 Crore rows in each table so appending or bookmark will hang the report.

Any idea or any type for fix will be appreciated.

I have attached my smaple report for your refernce.

https://1drv.ms/u/s!AjqH7k_M5ZVEg0SazF5hc1-nR3TK?e=DdxUYB

Thanks in advance

Shivayogi

 

[ShreyasB]

Hi Team,

Any approach to the solution ?

Please refer the attached pbix for your refrence to try on it.

Thanks

[amitchandak]

@ShreyasB , Assume you have three measures from table Januray , Feb , Mar : M1, M2, M3

Switch(Month(Maxx(allselected('Date'), [Date])) ,

1, [M1],

2,[M2],

[M3]

)

[ShreyasB]

Hi Amit,

For measures it will work as we can use selected value and based on that we can switch the measure.

For me i want to use the columns from different tables.

If i select January in slicer my visaul should display J and for February it should display F.

In values column i have different values in both tables.

I need to display the values in a table visual.

Thanks in advance.