ribbon chart - indicate current day

[hugus]

Hi All

I have a ribbon chart with values for product quality by day. There is actual data for today and in the past and forecast data for days in the future. It us used at a pre-start LEAN meeting where i want users to quickly see "where we have been, where we are today, and where we are heading" with regards to quality. 

To help - i want to indicate on the chart where "today" is.......either a straight line that always shows on the current day or somehow fade the colours slightly for days in the past.

note the chart always shows 5 days ago until 7 days from now....

[v-alq-msft]

Hi, @hugus 

Based on your description, I created data to reprodue your scenario.

Table:

You may create two measures as below.

DisplayColor = 
IF(
    SELECTEDVALUE('Table'[Date]) = TODAY(),
    "red","blue"
)

visual control = 
var _date = SELECTEDVALUE('Table'[Date])
var _datediffago = DATEDIFF(_date,TODAY(),DAY)
var _datedifffuture = DATEDIFF(TODAY(),_date,DAY)
return
IF(
    OR(
        AND(
            _datediffago>=0,
            _datediffago<=5
        ),
        AND(
            _datedifffuture>=0,
            _datedifffuture<=7
        )
    ),
    1,
    0
)

Then you may make the visual selected, go to 'Visualizations' ribbon, click 'Format'=> 'Data colors'=>'Conditional formatting'. You may set it as below.

Finally you need to put the 'visual control' meausre in the visual level filter. Here is the result. It displays the data in the past five days and the data in the next seven days.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[hugus]

thank you @v-alq-msft - this looks great however i cannot see where conditional formatting is an option for ribbon charts....

[v-alq-msft]

Hi, @hugus 

If you put more than one fields in 'Value', it has the same effect as putting a field in the 'Legend'. You may have a try. When you put a field in 'Legend', then you can only put a field in 'Value'. If you have several fields in 'Value', then you can't  put a field in 'Legend'.

Best Regards

Allan

[hugus]

Yes i see - so I'm needing 3 fields for 'value'......in that case i guess this cannot be done?

thank you for your assistance

[v-alq-msft]

Hi, @hugus 

It is unsupported to achieve you requirement in Power BI currently. I'd like to suggest you post a new idea in Idea Forum and add your comments there to improve Power BI for making this feature coming sooner.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-alq-msft]

Hi, @hugus 

I have modified my data.

I wonder if you have a field put on the 'Legend'. If it is, 'Conditional formatting' will not appear. It classifies the visual as the 'Category'.  It is designed to be like this.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

It seems like conditional control in only available when you have only one series

color = if(max('Calendar'[Date])=date(2020,02,15),"red","green")

I was able to change color using the Field option and a measure. The same way it has been given here https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

You need to try like

color = if(max('Calendar'[Date])=Today(),"red","green")

,