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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
pbidani
Regular Visitor

Power BI - Matrix - how to put '*' in a cell value and who to show color indicators for row names?

Hello,

I will appreciate your suggestions for the below 2 questions -- 

1) how do we put* in cell values based on certain conditions?

2) can we put color markers for rows?

Thanks,

Pav

 

 

pbidani_0-1737572992951.png

 

2 REPLIES 2
v-jialongy-msft
Community Support
Community Support

Hi @pbidani 

Currently, it is not possible to apply conditional formatting to matrix row headers.

For your another question, you just need to write a DAX expression based on the logic of how you want to display '*'.

For example, here is my example data:

vjialongymsft_0-1737595248244.png


Assume you want to display blank values as '*' . 

 

You can use the following measure:

 

Measure = IF(SELECTEDVALUE('Table'[Value]) = BLANK(),"*",SELECTEDVALUE('Table'[Value]))

 

Result:

 

vjialongymsft_1-1737595360405.png

 

 

 

 

 

Best Regards,

Jayleny

 

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

pbidani
Regular Visitor

How to --- not --- who to --- who to show color indicators for row names

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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