Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I would like to add custom line in matrix visual to display the current date.
Please see the sample screenshot I'm trying to come up with.
Would appreciate if you can assist or provide any other alternative to do,
Regards,
Chiru
Hi, @chiru5262
Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.
Best Regards,
Community Support Team _ Eason
You have to use icon formatting, if you can create some number around each date then you can use one under conditional formatting, Otherwise use icon measure
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
In the above link, both are given. Icon measure is in later part of the article
Custom icon theme
https://powerbi.tips/2019/07/icons-upon-icons/
Hi Amitchandak,
Thank you for reply, I've alredy done the conditional formating using icons, my issue here is to create a custom line like the one appears "as timeline" slicer to highlight the current date.
See below, I want something like in yellow to showcase todays date.
Appreciate your help.
Hi , @chiru5262
I'm afraid it's hard to create a custom line in matrix.
You can try to create a measure and applied to the background conditional formating of value to achieve a similar effect
Best Regards,
Community Support Team _ Eason
Hi Mate,
Thanks for you advise, but is it possible to do the same without filtering on the date slicer.
I mean I want to highlight the background by default with the current date( today), is it possible?
Please advise.
Kind Regards,
Chiru
Hi , @chiru5262
Just need to change the measure as below:
Measure1 = IF(SELECTEDVALUE(Table1[Date])=TODAY(),"red")
or
Measure1 =
var today =TODAY()
return IF(SELECTEDVALUE(Table1[Date])=today,"red")
(Since there is no data for 2020/7/20, I assumed that today is 2020/07/01 and tested here)
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Mate,
Thank you for your reply, but nope it still didnt work though.
Not sure why but still unable to highlight the column and you are right there are situations where there is no data for todays date.
So basically if it can highlight the background for todays date should also works for me but not sure how?
Sorry for the inconvenience.
Cheers,
Chiru
Hi , @chiru5262
Is your date field continuous?
From your first screenshot, you only need to reach the level of month and not the level of day.
If today’s date does not exist in the date field, as a workaround ,just need to change the measure as below:
Measure1 =
var this_month =Month(TODAY())
return IF(Month(SELECTEDVALUE(Table1[Date]))=this_month,"red")
Best Regards,
Community Support Team _ Eason
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |