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
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.

       

       

      • Sam09's avatar
        Sam09
        Frequent Visitor
        7 years ago

        AkhilAshok - Thanks for the inputs. I'm using older version of PowerBI(Mar 2018) and it doesn't have "Preview Features" option to select Composite Models option. Is there any alternate way to do it using Measures or DAX formula?