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

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?

      • AkhilAshok's avatar
        AkhilAshok
        Solution Sage
        7 years ago

        In that case, assuming your source is SQL Server, you can add a new table with the below Custom SQL (in the GetData -> SQL Databae dialogue, after entering ur Server and DB, Click Advanced option, and enter the below SQL), and keep it as diconnected table:

         

        SELECT 'Prod2016' AS model
UNION ALL 
SELECT 'Prod2017'
UNION ALL 
SELECT 'Prod2018'