Top 5 DAX tricks for super effective Power BI dashboards | Zebra BI Webinar

[@dariuszspiewak5624]

Yeah.... The Zebra BI visuals are a true piece of art, without a doubt. They are much more than great. Congratulations to all those who have worked hard on the design and implementation.

[@ZebraBI]

Thank you so much Dariusz for your kind words! We work really hard to continue making the best product possible and help everyone achieve actionable reporting. This kind of feedback gives us even more fuel and motivation. 🔥 Rock on!

[@ginespagan8583]

For a beginner in Power BI (DAX, visualizations, etc...) this is one of the best webinars I have seen so far. I hope that soon I will be able to start using Zebra BI visual in my day to day work. Thank you very much for sharing!

[@ZebraBI]

Thank you for the kind words! We hope to see you join our Zebra BI community soon :)

[@isidrebague3659]

Congratulations. Very well explained. Especially, clear and simple English is appreciated. This helps those who do not usually speak the language.

[@ZebraBI]

Isidre thank you very much on your feedback, it means a lot to us. We try to be as direct and understood as we can, while presenting solutions and it is honestly great to hear that we are achieving this goal. Customer UX with our product is our top concern and we are making it seamless - so please go ahead and start free trial & let us know how it works for you. Best regards, Mike.

[@xMastJedi]

Great advertisement for Zebra visuals.

[@xuanpham5955]

This is such a wonderful tutorial! All the tricks are super relevant that can be applied immediately and in numerous occasions. Thank you so much!!!

[@ZebraBI]

Thank you! Always happy to help :)

[@willameena1334]

Wonderful video! I've been delving deeper into DAX and it makes such a huge difference for effectiveness when using Power Bi. Thanks for such clear explanations! :)

[@ZebraBI]

Thank you so much for your feedback! We love creating videos for you and happy to hear that you find them helpful :)

[@rossitzaslavova4193]

In the demo you demonstrated how easily we can compare performance between the current year periods to same periods previous year and the plan (if there is such), but often for operational dashboards we need to compare periods in the current year (like week over week, moth over month or quarter over quarter). It doesn't seams possible with this visual. For some industries (like financial services) what had happened previous years has only historical value.

[@ZebraBI]

Hi Rossitza, great point, that's exactly why we recommend using the DATEADD DAX function! You can easily add measures for previous month or previous quarter (just select month or quarter instead of year in the last function parameter). Then add those measures into the Previous Year bucket in Zebra BI visuals. Both Zebra BI visuals support any kind of time comparison, they are not limited to same period last year comparison. Similarly, you can create a measure for previous week or 7 days ago. In operational reporting, you can also use a fixed benchmark instead of a formal plan (e.g. add a simple measure for 95% on-time delivery target, etc. ).

[@jitendratrivedi7889]

Great presentation, suggest you should format measures for easy to read and understand..

[@ZebraBI]

Thanks, Jitendra, for your feedback. We'll keep it in mind when creating future videos!

[@dariuszspiewak5624]

There's a golden rule of DAX that says: Never filter a table when you can filter a column. The principal reason for this is that if put a whole table as a filter in CALCULATE, the engine will have to place filters on ALL THE COLUMNS of the expanded table and this in turn will put a lot of burden on the calculation engine, hence slowing DAX tremendously (sometimes to the point where the calculation freezes, I've seen this in the wild not once). So, one should never write code like: calculate( [measure], filter( YourTable, YourTable[field] = value ) ) Instead, this pattern should always be used: calculate( [measure], keepfilters( YourTable[field] = value ) ) Just to clarify and give a little warning to the uninitiated.

[@ZebraBI]

Great comment, Dariusz Spiewak, thank you for your input! 🙌

[@badora_koora]

Thank you, this is very interesting

[@ZebraBI]

You're very welcome

[@venkatagopi.m6842]

Hi, How can we add MAT and YTD in the calendar you created, any help would be much appreciated.

[@ZebraBI]

You can do that by creating calculated column(s) in your Calendar table. Try combining "selected date" with time intelligence formulas as in our case.

[@MrPrakashsomani]

One of the best. Thanks for sharing.

[@ZebraBI]

Thank you, Prakso!

[@adighose]

Hi the calender technique is really good can you share the code for the addcolumn model

[@ZebraBI]

Aditya the DAX code and the exact same PBIX file as used in the webinar is available on this link: zebrabi.com/dax-tricks-power-bi-webinar/ - Go ahead and download it for free.

[@ks.karthick3356]

Hi, good video, I think so u missed How to add this visualization May I know the two visualization names

[@ZebraBI]

Hi Ks.karthick, the two Power BI custom that we offer are Zebra BI PowerCharts and Zebra BI PowerTables. Here are the instructions on how to import them to your Power BI: zebrabi.com/power-bi-custom-visuals/importing-zebra-bi-visuals/

[@AnjaHolyaru]

hii sir please explain how create monthly and ytd chart

[@ZebraBI]

Check it out in this template: zebrabi.com/template/sales-dashboard-power-bi-template/

[@iromatel9569]

Thank you

[@AlessandroSilva-dl3vq]

Muito bom mesmo essa ferramenta incrível. Professor é possível mostrar em um mapa clientes sem Atendimentos em determinados períodos ao selecionar no segmentador o mês ou até mesmo uma categoria de produtos. Banco fvendas e banco dclientes e uma calendar. Vc tem algum exemplo de como faz isso pois pelo o que estive vendo só mostramos os que têm vendas . Obrigado pela atenção desde já!

[@ZebraBI]

@Alessandro Silva honestly sorry for this late reply and that we do not speak any Portuguese. Would you like us to help you somehow? This Google translation is not doing its best job giving us the context of your comment. Thank you.

[@atensari]

how to get data source excel file used in this demo. link provided in email "Examples" don't has this file.

[@ZebraBI]

The DAX code and the exact same PBIX file as used in the webinar is available on this link: zebrabi.com/dax-tricks-power-bi-webinar/ - Go ahead and download it for free.

[@ZebraBI]

It is not excel file - it is power bi file pbix

[@dreflp5024]

Great Video but the download link for the visual kept asking for payment

[@dreflp5024]

Kindly assist.

[@ZebraBI]

Hi @dre flp - thank you for contacting us on multiple channels. If we are not mistaken we have already send you a couple of links from our support and info channel in the time between this answer happened. Please let us know if it solved your problem and how are you satisfied with the testing period :) Best regards.

[@siddheshkatalkar7208]

Very cool presentation.

[@ZebraBI]

Thank you, Siddhesh 😀

[@AliTwaij]

very nice thankyou

[@ZebraBI]

Thank you, Ali!

[@pawlowski6132]

13:50 test

[@ZebraBI]

Joe would you care to add to the comment?

[@adighose]

Good video

[@ZebraBI]

Thank you Aditya. means a lot. Follow us for more power bi great content in the future.

[@gxsoft]

Wow! Your Presentation is AMAZING, let me congrats a LOT! and your Visualization are explode my mind, you have a really good #Viz, Thank you, VERY MUCH! gab

[@ZebraBI]

We absolutely love to hear that Gabriel! It makes so much sense putting effort into our videos, so you guys can directly benefit from them - THANK YOU!

[@junukpm]

Hi it's really awesome, your explanation is cool. I have one doubt When we are using BI Report Server How we make many to many relationship...? I think you can help me. Thanks in advance

[@ZebraBI]

Hi Junaise, try to avoid many to many relationships if you can. That's typically a sign that something's wrong with your model. Perhaps you can eliminate the need for many to many relationships by preparing your data better in PowerQuery. Can you tell us more precisely what you're trying to achieve?

[@junukpm]

Thanks for your information From where did I get dashboard samples for hospitality management

[@xMastJedi]

@@junukpm Just create DIM table with distinct values and relate data between 2 tables through this DIM table.

[@MCW6229]

What is Scenario column, populated by PL??? Lack of explanation at this point in video; I created it and used the formulas to create AC and PY, but the new measures are useless when pulled into graphs... shows nothing

[@ZebraBI]

Hi Mark, Scenario is a column in the fact table with two attributes AC and PL to distinguish between Actual data and Plan data (later used by Andrej in the CALCULATE measures). It's really hard to say what's causing your visuals to show nothing. Can you please send more information to our support team at [e-mail]? We'd be very happy to help you!

[@artha79]

The powerbi screen so small... Better all screen just view the powerbi.

[@ZebraBI]

Thank you for your feedback. We will try to improve the viewing experience.

[@HellenofTroy897]

We just need to see the formulas and report views. It's not necessary to see you sir.

[@ZebraBI]

:) thank you for your feedback, Judith Okemwa, but some people do indeed prefer to see the face of the speaker :)

[@scottbitters8989]

When is a Power Bi dashboard not a dashboard?, answer when it is a report. Wish people would stop interchanging the terminology when you are searching for dashboard vids.

[@ZebraBI]

Hi Scott. Every understandable and actionable Power BI Dashboard consists of elements within well-prepared report pages. We understand that the confusion comes from the ‘Power BI Dashboard’ having a dedicated naming convention within the Power Platform. However, the word dashboard in itself has a more general and well understood meaning as being: a graphical report (as on a website) of various data relevant to a particular business, group, etc.