Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
chiru5262
Helper III
Helper III

Adding a Custom Line in matrix visual

Hi,

 

I would like to add custom line in matrix visual to display the current date.

Sample.JPG

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

8 REPLIES 8
v-easonf-msft
Community Support
Community Support

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

 

amitchandak
Super User
Super User

@chiru5262 ,

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.Sample1.JPG

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

75.png

 

 

 

 

 

 

 

 

pbix  attached

 

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)


86.png

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.