Forum Discussion
Highlight bars in a combination chart (conditional formatting of bars)
- Anonymous2 years ago
I was unable to highlight the bars in the combo-diagram, but I could conditionally format the Total-labels per bar.
Hi Anonymous
SamWiseOwl Thank you very much for your prompt reply, please allow me to share some content here.
As you know, there is no way to highlight it. However, you can try presenting the data in other ways, such as:
Create a date table, dynamically obtain the latest date, and display the same month data by selecting the date through the slicer.
Create a table.
DATE =
CALENDAR(
DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY())),
DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()))
)
Create a slicer.
Create a measure.
Measure =
var _date = MONTH(SELECTEDVALUE('DATE'[Date]))
RETURN
IF(
ISFILTERED('DATE'[Date]),
CALCULATE(
SELECTEDVALUE('Table'[value]),
FILTER(
'Table',
MONTH('Table'[date]) = _date
)
),
SELECTEDVALUE('Table'[value])
)
Create a visual.
When you select a date in the slicer, visual dynamically displays the data for the same month.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I've booked this for a re-read, very cool!