Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power BI - User created Filter (Parameter Filter in Tableau)

Hi,

 

I am new to Power BI. I have one question ,please help. I have a tabular report with dollar values. I need to give an option to the users to display the values in millions, thousands or full number.

 

In tableau, i create a parameter filter (Create a parameter manually with these 3 options and divide the displayed value by million, thousands or 1 based on user selection) and users can dynamically change it on the report. Is there a way I can do this in Power BI. I have seen the parameter option in power BI , where the parameter selection will appear before the report is generated. Is there a way to get the parameter values as the Slicer values so that users can make the selections within the report same as any other filter?

 

Thanks for Reading!

Cyril Joy.

  • Anonymous's avatar
    Anonymous
    7 years ago

    This is easy to do using the Paramter table method. Thanks.

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks. How do we handle in Power BI If I have couple of filters similar to this? 

       

      1. Dollar Display (Milllion, Thousands or Full Amount)

      2. Currency (USD, GBP etc)

       

      Thanks.

      Cyril.

      • Anonymous's avatar
        Anonymous
        Not applicable

        This is easy to do using the Paramter table method. Thanks.