Applying custom conditional formatting using a Measure in Power BI

  Рет қаралды 34,124

BI Gorilla

BI Gorilla

Күн бұрын

Пікірлер: 26
@jazzista1967
@jazzista1967 3 жыл бұрын
Great Trick Rick! Like that idea of putting a measure as conditional formatting in top of another measure. I will try this at work today. Thanks for posting. And yes, post some more Powerquery and DAX tricks. This was extremely useful. Happy new Year!
@BIGorilla
@BIGorilla 3 жыл бұрын
This was an actual case my client had. After knowing this you can get very creative. And I will keep posting stuff Jazz, I have some more ideas in mind, will be posted soon! 🚀
@sarabashi1269
@sarabashi1269 Жыл бұрын
YOU SAVE MY TIME. THANK YOU
@monicakim777
@monicakim777 8 ай бұрын
This is super helpful thank you!
@SunilKumarMutte
@SunilKumarMutte 3 жыл бұрын
Thanks, its a great tip however I would like to know how to compare 1-Jan vs 1-Feb or 1-Feb vs 1-Mar, whether value is increased or decreased
@ebogart42
@ebogart42 7 ай бұрын
great information - THANK YOU!
@Montreal_powerbi_connect
@Montreal_powerbi_connect 3 жыл бұрын
Hello, thanks for good tip, some custom visuals doesn't have conditional formatting, how can I add it to my visual ?
@BIGorilla
@BIGorilla 3 жыл бұрын
Some visuals don't support it im afraid. The visual will show the options when it's available. Who knows they may support it in the future! Cheers Rick
@Montreal_powerbi_connect
@Montreal_powerbi_connect 3 жыл бұрын
@@BIGorilla thanks for your replay.
@kevinmcq7968
@kevinmcq7968 Жыл бұрын
this is amazing, thank you
@АртемШибанов-е3т
@АртемШибанов-е3т 3 жыл бұрын
Nice trick, very usefull. thanks for good explaining.
@BIGorilla
@BIGorilla 3 жыл бұрын
Thank you!! Enjoy
@josemarquez3885
@josemarquez3885 3 жыл бұрын
Hello! Is there a way to conditional formatting a column inside a matrix that comes from an unpivot column, I try this rule but it doesn't work properly: Rule = IF(MAX('Backlogs list testing'[Month])="06 June OA vs Actuals",0 I need to apply the conditional formatting to just one column. Thanks in advance.
@oneallwyn
@oneallwyn 3 жыл бұрын
Wow, that was so awesome... you are subscribed
@BIGorilla
@BIGorilla 3 жыл бұрын
Thanks Allwyn. Powerful stuff!
@siphesihleyapi4102
@siphesihleyapi4102 3 жыл бұрын
How do i compare adjacent columns in a matrix; if column 1 > column 2 then show down error icon?
@BIGorilla
@BIGorilla 3 жыл бұрын
Depends what you put in the columns. If its months. You can change the filter context to generate the earlier cells
@hamzamottali3567
@hamzamottali3567 3 жыл бұрын
Hello , thank you for your efforts, please I have a question about tables ..can I make condition date formula or some rules in order to change the rows color in terms of what I want ? is there any way to cotrole the row color by condition date ? i know that you can change the row color but not by a condition that you made. for example if date A < date B make the row in red color etc ... thank you for your help
@BIGorilla
@BIGorilla 3 жыл бұрын
I believe it's possible. The logic should be in the measure. So you can Base the conditional formatting on the measure. Do you have a sample file to work with?
@hamzamottali3567
@hamzamottali3567 3 жыл бұрын
@@BIGorilla yes i have but how can I send it for you ? is there any address email or some thing like that ?
@BIGorilla
@BIGorilla 3 жыл бұрын
@@hamzamottali3567 If you like, you can share it at rick@gorilla.bi. Please indicate your desired outcomes :)
@hamzamottali3567
@hamzamottali3567 3 жыл бұрын
@@BIGorilla Absolutly i will do that Thank you 🙂
@mitalia38
@mitalia38 3 жыл бұрын
@@BIGorilla Was there a solution here? I would like to utilize for a forecast waterfall report.
@zzzzzzzzzzzzzzzz9
@zzzzzzzzzzzzzzzz9 3 жыл бұрын
Im new here.
@BIGorilla
@BIGorilla 3 жыл бұрын
Welcome to the Channel!
I tricked MrBeast into giving me his channel
00:58
Jesser
Рет қаралды 24 МЛН
бабл ти гель для душа // Eva mash
01:00
EVA mash
Рет қаралды 3,8 МЛН
CAN YOU DO THIS ?
00:23
STORROR
Рет қаралды 43 МЛН
Elza love to eat chiken🍗⚡ #dog #pets
00:17
ElzaDog
Рет қаралды 12 МЛН
CUSTOM FORMAT STRINGS in Power BI | Making sense of ##0,.0 K
13:51
How to Power BI
Рет қаралды 49 М.
Conditional Formatting with Field Parameters in Power BI???
5:40
Guy in a Cube
Рет қаралды 43 М.
Fast Running Totals in Power Query (Complete Guide)
29:16
BI Gorilla
Рет қаралды 31 М.
Power BI Conditional formatting using Measures
7:44
Access Analytic
Рет қаралды 12 М.
I tricked MrBeast into giving me his channel
00:58
Jesser
Рет қаралды 24 МЛН