Forum Discussion

Miruthan's avatar
Miruthan
Icon for Advocate V rankAdvocate V
8 years ago
Solved

Change/apply parameter to visual level

Hi experts,   I explored the parameter option in PowerBI, and curious to know, Is it possible to change/apply filter on visual level.?   For instance:-   I have a tree map which shows data by r...
Interesting Links
Tips and Tricks
Tutorial Requests
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Miruthan,

     

    If all dimension tables share the same table structure, you can "Append" them as a single table. Before combination, you could add a custom column in each Dim_table which identifies its own table name, "regional", "department" or "country". Then, when you create report, add this custom column into slicer, to filter data dispalyed in visual.

     

    If these dimension tables have different structures, you should apply query parameter to dynamically load data tables. You can change the parameter value on report page.

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Miruthan,

 

If all dimension tables share the same table structure, you can "Append" them as a single table. Before combination, you could add a custom column in each Dim_table which identifies its own table name, "regional", "department" or "country". Then, when you create report, add this custom column into slicer, to filter data dispalyed in visual.

 

If these dimension tables have different structures, you should apply query parameter to dynamically load data tables. You can change the parameter value on report page.

 

Best regards,

Yuliana Gu