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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Kornholio1313
New Member

How to change Formatting with icons to specific

HI,

 

I have a chart that shows Branded vs UnBranded. The Rate on the right is conditionally formatted. ALthough, i dont want it to look at all the rates and give me the colors, I want it to look at the Branded vs UnBranded and color icons based on those two outputs and not all lines. Here is what i have in PBI.

   
Kornholio1313_0-1695927294554.png

Is should be 

 

Branded | Project Name | Rate | UP ARROW

Unbranded | Project Name | Rate | DOWN ARROW

 

Branded | Project Name | Rate | DOWN ARROW

Unbranded | Project Name | Rate | UP ARROW

 

Branded | Project Name | Rate | UP ARROW

Unbranded | Project Name | Rate | DOWN ARROW

7 REPLIES 7
jeroendekker
Frequent Visitor

I can be dynamic if you create a good measure.

If you do not show your data and explain exactly clearly what you want nobody here can help you write te specific measure. The DAX is depending on the model.  

ChiragGarg2512
Super User
Super User

@Kornholio1313 , Go to cell element in format visual of the table visual and select the column on which the conditional formatting is set. Then in icons go conditional format and change the style from shapes to arrows. The option of arrows are from all 8 directions to 3[Up Down right]. Change the conditions accordingly and can also remove any arrow as per convinience. 

Thank You, if solves the issue mark as solution.

This is ok, but it has to be dynamic, not set. Meaning Branded Rate could be 40% one timeframe and 65% the next same goes for UnBranded. The idea is to show, no matter the number, who won in green. So, if Branded Engagment Rate is =65% and UnBranded is =45%, then Branded rate is colored GREEN and UnBranded is RED. These rates will change when the dates are changed, so the next time UnBranded could =65% and Branded 45%, therefore UnBranded Engagement Rate would be in GREEN

Then there is a need to create a measure that decides who won and then use that measure in conditional formatting. For Ex. make a measure that marks win and loss and then using that measure that in condtional formatting marking that win is green and loss is red.

hi @ChiragGarg2512 , tht would be nice, but this is dynamic, so the winning % could be any number when you change the date timeframe, it could be 55%, 55.4%, 56.5%, etc. so i cant just hardcode a winning %. Any other ideas?

jeroendekker
Frequent Visitor

jeroendekker_0-1695931850916.png

I am not sure when you want the arrow to go up or down but you could do it like above

jeroendekker_1-1695931942931.png

if your logic is to complex for this option. You could also create a measure and use it as a field value in conditional formatting. Something like this

jeroendekker_2-1695932487239.png

More info:  Power BI Icon Names for Conditional Formatting Using DAX - RADACAD

 

This did not acomplish what i needed to do, has to be dynamic, thanks. I am going to go back to using Tableau now

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.