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 - 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'
      • Sam09's avatar
        Sam09
        Frequent Visitor
        7 years ago

        AkhilAshok - Awesome, now the table is created with values in it (Prod2016,Prod2017,Prod2018), but how to do the below logic part, the measure(Values in previous Year ) created by  in the suggested answers above..:

        SELECTEDVALUE ( SlicerTable[model] ) - 1