Using DAX to control a chart range in Power BI

Ho to use DAX expressions to control and customize the range of charts in Power BI.
Article and download: sql.bi/811841?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...

[@nikolagrkovic8769]

These tips and tricks are golden and much needed for day to day job in PowerBI. I had to figure out most of "tricks" like the one in the video by myseft in order to get exactly what my clients need. However, nothing could ne possible if I weren't to pick up "Definitve guide to DAX" and bite it hard. That book is super hard, but a super masterpiece. Thanks for everything!

[@elrevesyelderecho]

0:00 - 1:34 Intro 1:35 - 7:12 First Example 7:13 - 11:32 Second Example 11:33 - 24:38 Third Example 24:39 Conclusion

[@gustavobarbosa906]

Thank you, Alberto! Using a measure to define the y range is very useful and I have used in the past not only for chart comparison but also because PBI's calculation of the y range sometimes leaves the topmost data (or total) label in a bad position. So, I calculate the value and add 10 or 20% to it thus leaving more space for the label. However, I had never done it for a dynamic comparison as in your last example. And this proves to me that I always profit from watching your lessons. Thanks again!

[@ikar2k]

Brilliant video! Mille gracie! 🤗

[@riesgoscootregua2462]

Gracias maestro Ferrari; el limite es la imaginación

[@matthewdufty606]

Another great dax video! Thank you so much. I really enjoy these

[@kkaurkify]

Thank you Alberto. It's amazing what ideas can come from you.

[@NancyMancarious]

Thank you so much for this gem! Now I have the same example 03 with a slight (or big) difference. Instead of 1 filter per graph, I have about at least 5 filters (country, year, quarter, month, ... etc). It seems to me that doing the solution for Example 3 adds a lot of background work (and clutter) that I am not a fan of. Is there an easier way to achieve the same thing with such many filters?

[@rokiczaaa]

I love watching your videos. Another idea to apply in my reports :)

[@vijaykrishnan4151]

Excellent Video... just love your clear explanation :)

[@geraldschaufler9819]

Great stuff, thank you for sharing!!

[@Bharath_PBI]

Thank you, that's another useful solution !!

[@williamrhopkins]

Very nice. Do you have a way of controlling the Y axis depending on the drill level. Say I want to be able to set the Y axis range to one value when the visual is displaying Years and another if I drill down to Months

[@ramziyaseen3200]

Nice

[@ajaypanchal8844]

How can I show two continuous x-axis in same chart with same range?

[@lionels839]

Nice! What about the X axis ? say I have a year and a month slicers and when I want to see the full year X axis is months and if I select both slicers year and months X axis is days

[@hailin1354]

Fantastic!

[@nikolagrkovic8769]

One question, though. I was able to obtain basically same results by using USERELATIONSHIP instead of using TREATAS pattern. That pattern with USERELATIONSHIP proves to be useful when you need, for example, to compare sales amount for two years user selects in slicers in same matrix. Is there a downside using USERELATIONSHIP instead of TREATAS?

[@SQLBI]

If you create the underlying relationships (as inactive ones) yes, it's the same. For a small number of unique values (as it is the case of brands) there are no performance differences, the USERELATIONSHIP solution is faster if the cardinality is bigger (e.g. thousands or more).

[@nikolagrkovic8769]

Thanks@@SQLBI

[@willyms]

Nice beard Master ;)