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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Formatting

I have a couple of questions. 

1) I have created flag ( 1,2) and top of it applied conditional formatting ICONs. But i wanted to hide values and show only ICONS in  the dashboard?

 

Untitled.png

 

2) Is there any option do sorting of drill thorugh to in line with child report tabs order.

 

1 ACCEPTED SOLUTION

@Anonymous , You can use unichar icon and conditional color formatting on top of it

refer this solution in past if that can help

https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

 

list of all unichar is available here

https://exceleratorbi.com.au/dax-unichar-function-power-bi/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

6 REPLIES 6
Fowmy
Super User
Super User

@Anonymous 

Go to Conditional Formatting Setting and choose Icon Only

Fowmy_0-1599855779228.png

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

There is no issue with icons. But my questions when move mouse on icons it showing the backend values as well. How to keep the values away and show only icons.

 

@Anonymous , You can use unichar icon and conditional color formatting on top of it

refer this solution in past if that can help

https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

 

list of all unichar is available here

https://exceleratorbi.com.au/dax-unichar-function-power-bi/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@Anonymous In the Format pane, do you have the option to turn off the Tooltip?

Greg_Deckler_0-1599865231436.png

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Anonymous 

 

use Measure1 to display and in conditional formatting use the Formating measure.​
MEASURE1=UNICHAR(11044)
FORMATING=SWITCH([COLUMN],1,#000000,2,#909090)

 

 

 

@Anonymous 

I am not sure if it possible to hide the value showing up.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.