Forum Discussion

Sam09's avatar
Sam09
Frequent Visitor
7 years ago

dynamically changing the column display based on slicer selection..

Is it possible to dynamically change the columns which i'm showing in the table visualization based on the option selected in the slicer. I have the below table: MobID Pname level Model ...
Need Help
AkhilAshok's avatar
AkhilAshok
Solution Sage
7 years ago

You can create 2 generic measures like this and use:

 

Count Previous Year =
SWITCH ( SELECTEDVALUE ( ProdData[Model] ), "2017", [count2016], [count2017] )


Count Selected Year =
SWITCH ( SELECTEDVALUE ( ProdData[Model] ), "2017", [count2017], [count2018] )
Sam09's avatar
Sam09
Frequent Visitor
7 years ago

AkhilAshok - The results are not displayed correctly when selected 2017. Any inputs?

  • AkhilAshok's avatar
    AkhilAshok
    Solution Sage
    7 years ago

    Have u tried the solution from v-yulgu-msft? That should work fine. My approach may not work, since the filter on year will filter the Pname dimensions. So you have to create a diconnected table with Year values and use that as a slicer.

    • Sam09's avatar
      Sam09
      Frequent Visitor
      7 years ago

      AkhilAshok - Yes, solution from v-yulgu-msft works but the issue is i cannot able to create a new table in my file as i'm fetching the data using directQuery instead of import..

      • AkhilAshok's avatar
        AkhilAshok
        Solution Sage
        7 years ago

        Is PBI Report DirectQuery from SQL Server or SSAS? If from SQL Server, you can now enable the preview feature Composite Models which helps you to combine, data import with DirectQuery.