That's helped me a lot, thanks! To use it for highlighting past periods, just change "-" to ">=" in the code, like this: IsFuturePeriod = VAR CurrentPeriod = MAX('SuC Projects By Month Filled'[Date]) RETURN IF( DATE(YEAR(CurrentPeriod),MONTH(CurrentPeriod),1) >= DATE(YEAR(TODAY()),MONTH(TODAY()),1), 1, 0 )
Nice tip. I have a scenario where I have a customer table that has a date column for sales uplift estimate date. Using a bar chart I want to be able to filter on a customer and the conditional formatting to highlight the sales uplift estimated month rather than the current month. How would I go about modifying the dax code?Thanks.
Hi Parker, great video! If I wanted to highlight the most recent entry selected in the date range, which won't always be today(), is that possible? I'm basically looking to apply conditional formatting based on MAX and MIN targets for the Amount but only apply this formatting the most recent column in the bar chart.
Great video! Is it possible when you have two variables in a Bar chart, to use Conditional Formating, so if a value is greater compared to the other value it changes color?
Hey Agustin! This is possible by creating another measure that compares your two values. You can then use this new measure in your conditional formatting!
@@tarunr666 Whoa that is awesome! I had no idea. I wish I could append on to this video... Or maybe that can be the next video on the channel. Thanks for the tip, Tarun!
That's helped me a lot, thanks! To use it for highlighting past periods, just change "-" to ">=" in the code, like this:
IsFuturePeriod =
VAR CurrentPeriod = MAX('SuC Projects By Month Filled'[Date])
RETURN
IF(
DATE(YEAR(CurrentPeriod),MONTH(CurrentPeriod),1) >= DATE(YEAR(TODAY()),MONTH(TODAY()),1),
1,
0
)
Great video. Can also use this conditional formatting for the names of the X-axis (Jan, Feb, Mar, ...) ? Thanks
Nice tip. I have a scenario where I have a customer table that has a date column for sales uplift estimate date. Using a bar chart I want to be able to filter on a customer and the conditional formatting to highlight the sales uplift estimated month rather than the current month. How would I go about modifying the dax code?Thanks.
Hi Parker, great video! If I wanted to highlight the most recent entry selected in the date range, which won't always be today(), is that possible? I'm basically looking to apply conditional formatting based on MAX and MIN targets for the Amount but only apply this formatting the most recent column in the bar chart.
Nice one, I used same approach for table background color, but I didn't think of using it on bar charts. Good job
Thanks Tomislav!
How would you go about highlighting a column using a selected value? and everything thats not selected is grey'd out?
Great video! Is it possible when you have two variables in a Bar chart, to use Conditional Formating, so if a value is greater compared to the other value it changes color?
Hey Agustin! This is possible by creating another measure that compares your two values. You can then use this new measure in your conditional formatting!
here you go......one more great tip...!! thank you so much....!!!
Haha thank you!
A VERRY important notice here is that you should use the Date IN the table you want this measure to work on NOT your connected Calendar in your model
THAT!!! is slick. Thank you.
Thanks Robert!
@@tarunr666 Whoa that is awesome! I had no idea. I wish I could append on to this video... Or maybe that can be the next video on the channel. Thanks for the tip, Tarun!
It is reverted for me 1 shows the as old months and 0 as current?
I figured it out! Your equals signs look like a minus sign! So I kept inserting the minus sign rather than equals in the IF statment.
Excellent tip, thanks
Sweet, thanks Jamal!
Very useful. thx for sharing
Thanks Mehdi!
Awesome, thx for sharing so much good tips and tricks ;)
I appreciate the support, Jonathan!
Cool!!!! Thanks!!
Thanks for watching Mauricio!
Great one
+Majd Yazigi Thanks! Glad you liked it