How to use FIELD PARAMETERS to switch AXIS or MEASURES in your charts // A Guide to Power BI 2022

In this video were going to go through how you can use field parameters to give your users the ability to switch your visuals axis dynamically.

-

🚩 Get Demo Files here

👍 Become a Patreon to support the channel and get free perks!

🛍 Get exclusive templates built using best practices here

❤ Other ways to support

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards

📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[annelaure]

Great video !! I was looking for a way to do the filtering on a table with field parameters in it for hours before finding your video, thank you !!

[oraclesql]

Thank you Fernan. This is the best video I've seen on Field Parameters.

[TayuanRebelo]

Fernan, I have a challenge for you:
I’m using the field parameter para switch the time series of my visuals between Year and Fiscal Week.
I want to keep X axis sorted by the time series (not by the values) in ascending order.
However, every time I switch the field, the X axis is sorted back by the values.

It’s driving me crazy!!!

[vanishedxu]

This is amazing! Thank you Fernan! Can wait to try it out!

[vishnukanth]

Hello fernan can you make a video on the same secenario but I need to create pramters for 3 fiscal years state fiscal year, fedaral fiscal year, calendar year please help me with this I'm following 3 parameters because different states in usa follows diffrent months for fiscal year I hope you will post a video on this secenario

[dhwxfey]

one drawback is you can't adjust number of digits after comma for those measures from field to be shown differently on the visual... Does anybody know how to do it?

[sriramya]

Thanks for the video. I have a question. Can we use Field Parameters to a line graph with multiple lines?

[sushreesangeetajena]

Thank you for the amazing video. If I want to add what if parameters(for eg, cost, price, disc%) to this, how do I adjust the dynamic axes. Could you please help on this?

[mirrrvelll]

Great trick! I just replicated to my report =)nice!!

Question, is there any possibility to change those position number at the end of parameter measure automatically? I can imagine if there are like 10-15 but what about 50+? Anytime you need to change the order of them...

I can think of Power Query, where you can import all of your measures from Parameters and there sorting using Index and then copy it back to Power BI...

[jiteshkumar]

Hi fernan, thanks for you videos,
I have one query, that how we can select dynamic and static date on the selection of slicer,
Example I have one slicer having value (year, month, quarter and date ) and second slicer ( dynamic and static)
If I select dynamic from second slicer and month from first slicer then sales should show for 30 days window and if I select static then it should show actual month wise sales

[dnmlqkr]

HELLO FIRSTLY THANK YOU FOR THIS VIDEO .. actually i am trying to use both measure table where there is sales, cost, quatity and categories parameter where is categories, customers, product bt its not syncing please help me out

[sophiedeng]

Hi Fernan,
I didn't quite get it, why not just unselected "Blank" in the filter area for Top 10 customers/products? Why we still need to create another measure to exclude the column with Blank name?

[lopsan]

Can it be possible to have this but instead of changing the X-Axis with a slicer, have it be changed depending on another Bar Chart selection?

[basireddy]

can we do same thing changing x axis for direct query of sap hana data source

@please help me