New updates for Fields Parameter
- Problem Statements
Here we have three Report which are showing the info of “Sales amount by country”, “Sales amount by Group”, “Sales amount by region”
So it required lots of space in report so I want the solution for that
I want to create only one Visual and by using button click I want to switch x-axis.
So it is possible in Power BI using new Update in parameter
In the Power Bi Desktop click on the Modeling Ribbon We have option “New Parameter” so in that we have two options:-
1. Numeric range and
2. Fields as shown in bellow image, so we need to click on Fields option
After clicking on field will get new window “Parameters” as shown in bellow image.
So, in second textbox Name we must add Name of the Parameter “Territory 2” then add and reorder the fields from fields pane
Check “Add slicer to this page” option
Then click on Create
So, this “Territory 2” table will be available in Field Pane as shown below
And Territory 2 Slicer with the Dax Code as shown in bellow image.
After that create one new Visual “Column chart”
Add fields in this Column chart
as shown below X-axis will be Territory (Column from new created table) and add sales amount in Y-axis
So our Visuals will look like that and then by using only one button click we can change axis of visual
Conclusion: we can change axis on single button click rather than using Drilldown many times we can add as many axes as we want and switch them on single button click.
Thank you for reading!
Addend Analytics is a Microsoft Gold Partner based in Mumbai, India, and a branch office in the U.S. Addend has successfully implemented 100+ Microsoft Power BI and Business Central projects for 100+ clients across sectors like Financial Services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Switzerland, and Australia. Get a free consultation now by emailing us at firstname.lastname@example.org or Contact us.