DAX Fridays!

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

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

50% 1

In todays video I will show you how you can reuse conditional formatting using DAX and how to calculate max and min values of a series so you can highlight the min and max values.
#curbal #daxfridays #dax #powerbi
Keynotes:
1. Calculate Min and Max value of a series
2. Format min and max values
3. Reuse conditional formatting using DAX
Link to relevant resources:
SWITCH fucntion: • DAX Fridays! #15: SWITCH
MAXX function: • DAX Fridays! #72: MAX,...
ALLSELECTED function: • DAX Fridays! #22: ALLS...
Deep five on variables: • DAX Fridays! #122: DAX...
Get Northwind Dataset: • Northwind data source:...
Link to DAX Fridays survey: bit.ly/2MMM4KK
Here you can download all the pbix files: curbal.com/don...
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/cou...
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
curbal.com/pro...
Many thanks in advance!Here you can download all the pbix files: curbal.com/don...
▲▲▲▲▲▲▲▲▲▲
Our PLAYLISTS:
Join our DAX Fridays! Series: goo.gl/FtUWUX
Power BI dashboards for beginners: goo.gl/9YzyDP
Power BI Tips & Tricks: goo.gl/H6kUbP
Power Bi and Google Analytics: goo.gl/ZNsY8l
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#daxfridays #curbal #dax #powerbi #mvp

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

2 окт 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@akhilannan 5 лет назад

The conditional formatting disappers during sorting because, you haven't included the sorting column to the ALLSELECTED. The sorting column gets automatically included in the filter context of the visual.

@CurbalEN 5 лет назад

Oh, that’s gotta be it! Thanks for sharing, I will give it a go! /Ruth

@josepromero1452 5 лет назад

Hi Akhil, could you please explain a little bit more how to do?? I try to apply your solution but no result. Appart from this, it has no sense to have year-month unsorted... Thanks!!

@akhilannan 5 лет назад

@@josepromero1452 You can use: MAXX ( ALLSELECTED ( DimDate[Year-Month], DimDate[SortYearMonth] ), [Sales] ), provided you are using the May release of Power BI Desktop. For older versions, you could replace ALLSELECTED with ALL, since it doesn't support multiple arguments. But if you want to simulate same effect of ALLSELECTED in older versions, you may have to write little bit more complex DAX. Hope this helps.

@josepromero1452 5 лет назад

@@akhilannan Thanks a Lot!! IT WORKS!! Although I have last release, the sentence of two arguments for ALLSELECTED appears underlined (as an error), but if I press enter, it works.

@jacksonhz 5 лет назад

Where can I like the video multiple times? ¿! Great video thanks

@CurbalEN 5 лет назад

😂😂😂 you just did, thanks! /Ruth

@paulofakul 3 года назад

Excelent, I will aply this today. Thank you.

@LetsTalkPowerBI 5 лет назад

Solved the sorting problem and your Measure works really great :)

@LetsTalkPowerBI 5 лет назад

I tried to take the Monthnumber instead of the Date this solved the Problem. I don't know may be the Format "Date" is the problem (bug)?

@LetsTalkPowerBI 5 лет назад

And second: The Page 1 you can sort your "Year-Month" also after Monthnumber and than easily put a year slicer into the report. Than it works with sorting :)

@CurbalEN 5 лет назад

So you could sort month number and it showed correctly? Mmmmm have to try that! /Ruth

@sheilahart5989 5 лет назад

Hi Ruth - great video! FYI - It looks like your Revenue Formatting measure is referencing two different measures for sales - [Sales] and [sales].

@CurbalEN 5 лет назад

Oh, is it ? Let me check ! /Ruth

@CurbalEN 5 лет назад

Sales and sales is the same. There is only one sales measure. Phew!! /Ruth

@hamidsh4789 3 года назад

Hi Ruth, Thanks for your amazing videos.

@sureshgurbaxani9230 3 года назад

Please suggest how to use the same condition if the sales value is not a measure but a column

@PauL4ver 4 года назад

I love you. thanks for your video

@RobertoStaltari 5 лет назад

Those three dots could not have been hidden better :| Thanks Ruth

@CurbalEN 5 лет назад

I know right?? /Ruth

@ssma1368 4 года назад

Dear Ruth, Thanks a lot for this interesting tutorial! It seems the pbix files of this tutorial have a problem! I face this error when I try to open it on my computer: 'File address in my computer' is corrupt or an invalid report file.

@CurbalEN 4 года назад

Oh, so sorry, I am on holidays , would you mind reminding me next year? Thanks and merry Xmas! /Ruth

@lifeisstr4nge 5 лет назад

But doesn't the analytical formatting pane have the max line by default? I do use that

@CurbalEN 5 лет назад

Yes it does, this is another way to visualize max values. /Ruth

@horizon3919 5 лет назад

Thanks for video. From where we can get colour codes which you used during formatting.

@CurbalEN 5 лет назад

Just download the pbix file on curbal.com /Ruth

@juthathipjangjaras2948 5 лет назад

why sometime in parathesis i can see only built-in column that i can choose?

@CurbalEN 5 лет назад

Check this video for an explanation: m.ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-DwuAypulTLA.html /Ruth

@juanignacioXI 4 года назад

Came here for your Rept Video Ruth, u r great!

@CurbalEN 4 года назад

Great that the vids are useful ! /Ruth

@jimmyni1983 5 лет назад

Incredible! Thank you Ruth!

@CurbalEN 5 лет назад

You welcome! /Ruth

@implementedgmbh 5 лет назад

Great Video! Thanks Ruth!

@CurbalEN 5 лет назад

Thanks Ralf! /Ruth

@elrevesyelderecho 5 лет назад

7:09 good question! Did you try to sort it first and then add the formatting measure?

@christopherhastings2142 5 лет назад

I tried this on the download file, and still get the formatting error. Did you notice that the values are all formatted as highest value?

@elrevesyelderecho 5 лет назад

@@christopherhastings2142 Yeap. Looks like sort it by runs with Max at the same time. Could be use just Max rather than Maxx.

@CurbalEN 5 лет назад

MAX takes only a column though... /Ruth

@phanidivi3613 5 лет назад

Simply supb mam

@CurbalEN 5 лет назад

Awesome! /Ruth

@soy34mb 5 лет назад

Hola Ruth. Sabes como aplicar formato condicional que incluya no solo los valores, sino que también los totales cuando se usa una matrix. Por ejemplo, a los valores negativos los dejo en rojo y los positivos en verde, pero para los subtotales y totales, este formato no se cumple y siempre me queda en negro sin importar si es positivo o negativo. Ayuda!!! Muchas gracias :)

@elrevesyelderecho 5 лет назад

Patrick "Guy in a Cube" tiene uno o dos videos acerca de formato condicional

@CurbalEN 5 лет назад

Le das el enlace? Si es una matriz lo puedes poner en el “conditional formatting > elige la columna y pon : “apply to totals” /Ruth

@elrevesyelderecho 5 лет назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zHzSBNES6jE.html

@elrevesyelderecho 5 лет назад

No consigo el otro video en su canal...pero ese da ideas.

@CurbalEN 5 лет назад

Me parece que lo enseño en este vídeo: m.ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cboA5AtAPeg.html /Ruth