Forum Discussion

nish18_1990's avatar
nish18_1990
Helper III
10 months ago
Solved

Parameter selection for charts

Hi ,    I want to create a parameter for the selection on Category and Country in the chart . I have two chart in the below table structure.  I want to combine them in one . If i select Category in...
Tips and Tricks
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    10 months ago

    Thankyou, DataNinja777, for your response.

    Hi nish18_1990,

    We appreciate your query on the Microsoft Fabric Community Forum.

    Based on my understanding of the scenario, please find attached a screenshot and a sample PBIX file which may assist in resolving the issue:
    1.With Category View selected:


    2.With Country View selected:

    The slicer selects a view group, such as Category or Country. Each group is linked, via the GroupKey, to its respective fields in the ViewFields parameter table. The relationship dynamically controls which fields appear in the visual, thereby providing a seamless toggle between hierarchies.

    We hope the information provided helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.

    Thank you.

DataNinja777's avatar
DataNinja777
Super User
10 months ago

Hi nish18_1990 ,

 

Yes, you can absolutely combine those two charts into a single dynamic visual in Power BI. The most effective method is using a feature called Field Parameters, which is designed specifically for this purpose. It allows a user to select which data column (or hierarchy) they want to see in a chart using a simple slicer.

To get started, you will create the parameter itself. Navigate to the Modeling tab in the Power BI ribbon, click the New parameter button, and then select Fields. In the window that appears, you can give your parameter a name like "View By". Then, from your main data table, drag the fields you want to switch between into the box. To match your request, you should add Category, Sub Category, country, and State. When you click "Create", Power BI will automatically generate a new table for the parameter and place a slicer for it on your report page.

Next, you will build the visual that uses this new parameter. Add a Matrix visual to your report. From the newly created "View By" parameter table in your Fields pane, drag the "View By" field into the Rows section of the matrix. Then, add your measures to the Values section. These would be simple DAX calculations like the ones below.

Sum of Sales = SUM(Data[Sales])
Sum of Quantity Q2 = SUM(Data[Quantity Q2])

Once set up, the slicer will control the matrix. Selecting Category will group the data by Category and Sub Category, while selecting country will instantly pivot the matrix to show the data by country and State. This gives you one efficient visual that does the job of two.

 

Best regards,