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

Подписаться 46 тыс.

Просмотров 18 тыс.

50% 1

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/solutionsabroad/shop
solutionsabroad.co.uk/store
❤ Other ways to support
ko-fi.com/solutionsabroad
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 RU-vid.
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.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence

Опубликовано:

7 июн 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 22

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

@annelaure3974 4 месяца назад

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

@datayoda74 2 года назад

Nice touch!

@mcnater 2 года назад

Nice overview!

@PedroCabraldaCamara 2 года назад

Very good Fernan

@user-dh6wx3fe6y 5 часов назад

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?

@mjtr1970 Год назад

Excellent

@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 6 месяцев назад

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

@sushreesangeetajena7646 6 месяцев назад

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?

@sriramya3179 2 месяца назад

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

@jiteshkumar8228 11 месяцев назад

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

@96lopsan 10 месяцев назад

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

@user-dn7ml2qk7r 8 месяцев назад

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

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