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
bit.ly/3dJE2O7
👍 Become a Patreon to support the channel and get free perks!
/ solutionsabroad
🛍 Get exclusive templates built using best practices here
ko-fi.com/solu...
solutionsabroa...
❤ Other ways to support
ko-fi.com/solu...
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
🌍 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 KZbin.
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
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 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.micros...
#PowerBI #DataAnalytics #BusinessIntelligence

[@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!!!

[@manuelsandner942]

I have the exact same issue. Did you find a solution yet?

[@TayuanRebelo]

@@manuelsandner942 , I didn’t find a solution but I found a turnaround. If you keep the X-axis as categorical instead of continuous it keeps the sort the way you want.

[@moc2034]

If you are using a table/matrix you can add the original value eg sales $ and colour it white take off wrap put in trillions and make those columns tiny@@TayuanRebelo

[@annelaure3974]

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 !!

[@user-dh6wx3fe6y]

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?

[@vishnukanth1406]

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

[@oraclesql]

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

[@sriramya3179]

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

[@jiteshkumar8228]

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

[@user-dn7ml2qk7r]

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

[@sushreesangeetajena7646]

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?

[@mirrrvelll5164]

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...

[@SolutionsAbroad]

Hi there, thanks for watching my video! Sorry I'm not sure I fully understood this question here so I will answer what I think you mean. So I create a separate sorting table to manually control how they're displayed but if you're looking to slice your data in 50+ ways I dont think I've ever implemented something like this. It won't be automatic but you'll just need to create a separate table with the orders you're looking for

[@mirrrvelll5164]

@@SolutionsAbroad Yeah, I was afraid so. Okay thanks, need to reconsider better solution!

[@vanishedxu]

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

[@sophiedeng3436]

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?

[@96lopsan]

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?

[@basireddy1387]

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

[@mcnater]

Nice overview!

[@datayoda74]

Nice touch!

[@PedroCabraldaCamara]

Very good Fernan

[@mjtr1970]

Excellent