Thanks for this Gold! 5:44 Titlle 8:24 subtitle measure 9:17 high and lowest 13:11 adding subtitle 13:44 Window key + . for symbols 14:34 change color based on calculation
Can you create a video on how to create a Fiscal Year Calendar Table lets say from OrderDate column from Fact Table and the other required columns..I already have a calendar table
Hello, Can i get help on this Thanks ? Switch is only reading first line. If I change the order of the line and ,[Total Sales]=_highest,"green" then it will change to green so basically showing only one colour. Here is the code Highlights = VAR _table= SUMMARIZE( ALLSELECTED('Order Details') , Orders[OrderDate].[Month], "Sales", [Total Sales] ) VAR _highest= MAXX(_table,[Total Sales]) VAR _lowest = MINX(_table,[Total Sales]) RETURN SWITCH( TRUE() ,[Total Sales]=_lowest,"red" ,[Total Sales]=_highest,"green"
Thanks for this Gold!
5:44 Titlle
8:24 subtitle measure
9:17 high and lowest
13:11 adding subtitle
13:44 Window key + . for symbols
14:34 change color based on calculation
Thanks for this tutorial. I've searched for days on how to achieve this visual until I found your video. You're amazing!
thats a hell of a tutorial, so much worth information compacted in a assetive video. Instant subbed. Thanks for the video man!!
Thanks FERNAN for this tutorial very instructive and simple explanations ❤
thank you so much ... very informative... i was looking for this one ....
Wow, you are so amazing ! Thanks for the tutorials 😊
Insane video, thank you so much.
Greate and clear! Tnx
That is cool. Thanks for the post.
Thank you farhan
Can you create a video on how to create a Fiscal Year Calendar Table lets say from OrderDate column from Fact Table and the other required columns..I already have a calendar table
Cooool! Thanks 😊
🔥🔥🔥 Thank You!
that's a cool trick sir!
I can't believe they still haven't added the ability to use a function to change the markers. Love the hack but come on PMs let's get this corrected!
when I try to add the title and subtitle it won't let me. It just remains blank after selection with a red box around it, Any ideas?
same here. Have you found a solution? Thanks
change the title measure data type onto Text
You forgot the Trend line 😅
Hello, Can i get help on this Thanks ? Switch is only reading first line. If I change the order of the line and ,[Total Sales]=_highest,"green" then it will change to green so basically showing only one colour. Here is the code
Highlights = VAR _table= SUMMARIZE(
ALLSELECTED('Order Details')
, Orders[OrderDate].[Month], "Sales", [Total Sales]
)
VAR _highest= MAXX(_table,[Total Sales])
VAR _lowest = MINX(_table,[Total Sales])
RETURN
SWITCH(
TRUE()
,[Total Sales]=_lowest,"red"
,[Total Sales]=_highest,"green"
, "#FFFFFF00k"
)
did you solve it