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

[@trantrinhquocviet8420]

Great video! I can create multiple charts in one and switch between them using a parameter.

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

[@oraclesql]

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

[@vanishedxu]

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

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

[@sriramya3179]

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

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

[@mcnater]

Nice overview!

[@PedroCabraldaCamara]

Very good Fernan

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

[@datayoda74]

Nice touch!

[@trantrinhquocviet8420]

But I have a problem, how i can make color condiction with parameter.

[@karishmashewale-f1n]

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

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

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

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

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

[@basireddy1387]

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

[@mjtr1970]

Excellent

[@NikitaShilyaev]

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?