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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Gokul_G16
Resolver I
Resolver I

Row wise conditional formatting in Matrix table

Hi All,

Need you support to create the color coding as below mentined table values as row condition color in matrix table.

can you somone help on this. we have option column wise we can easily provide the color coding. 

Now my scenario seems every line which is lower to higher the values based on that we need to shown color condition.

Gokul_G16_1-1713427231542.png

 

Regards,
Gokul.

7 REPLIES 7
_AAndrade
Super User
Super User

Hi @Gokul_G16,

I did a quick example with same data and what I did was this:
Go to Format Page

_AAndrade_3-1713428583296.png

 

I've set up the conditional formatting as follows:

_AAndrade_2-1713428505354.png


The final output was this:

_AAndrade_4-1713428610543.png

If you need any hel please let me know.

 





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




Hi @_AAndrade ,

Thank you for your responce,

As mentinoed above details Q1 and Q2.. seems everyone is different measure based on that 4 measures , which one is high to low those way should be updated the row wise comparsion.

if you have any suggestion on this.


Regards,
Gokul

 

@Gokul_G16  each Quater column is one measure!?





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




Hi @_AAndrade 

yes, You are right. based on that we need to given the color format.


Regards,
Gokul

From my point of view, I think you're overcomplicating things that should be easy. There's probably some alternative solution, but with a simple calendar table, a measure and using my suggestion, you're likely to solve your problem quickly.

I'm don't know any workaround for your problem, sorry





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




Hi @_AAndrade 
 
Thank you for the assistance,

Adding @Arul  @amitchandak 

Need your swift support on this, would be greatly appreciated.

Thanks.


Hi @Gokul_G16 

 

Unfortunately that the power bi doesn't support this feature now.

You can just use conditional formatting separately in each measure, but between them.

If necessary, please submit your idea in Microsoft Fabric ideas:

Home (microsoft.com)

 

Best Regards

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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