Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I'm looking for disable settings for formatting
For example, if it is not set in the hint field, I want to prevent it from being selected.
↓Is there a way to do this?
Hi @Anonymous,
What type of disabling you mean? Remove data color formatting options or remove the detail color settings?
If you mean the format option, it is the basic part of the formatting option, you cant do custom to disable it.
If you mean the detailed data color setting of each data label, it is possible. You can enable conditional color formatting on data color, then this option will show the formatting based on expression instead of showing the detailed color settings.
Tips and tricks for formatting in reports#conditional-formatting-for-visualizations
Regards,
Xiaoxin Sheng
Hi Xiaoxin Sheng
Thank you so much for your reply.
and I'm sorry for the late reply.
>What type of disabling you mean? Remove data color formatting options or remove the detail color settings?
>If you mean the format option, it is the basic part of the formatting option, you cant do custom to disable it.
>If you mean the detailed data color setting of each data label, it is possible. You can enable conditional color formatting on data color, then this option will show the formatting based on expression instead of showing the detailed color settings.
I mean the format option. I see, I cant disable it.
Good thing we know it early.
Thank you so much.
Regards.
HI @Anonymous,
For this scenario, you can try to do the following steps to improve the usage of power bi visuals:
1. Submit an idea to add support to turn on/off the color formatting options on raw visuals.
2. Design a custom visual that similar to raw visuals, then you can remove the color formatting parts when you coding the formula.
Regards,
Xiaoxin Sheng
Hi @Anonymous : Xiaoxin Sheng,
Thank you for your reply and teach me!
>1. Submit an idea to add support to turn on/off the color formatting options on raw visuals.
sorry, idea is this site (https://ideas.powerbi.com/ideas/)?
>2. Design a custom visual that similar to raw visuals, then you can remove the color formatting parts when you coding the formula.
I am making custom visual now (pbiviz), "color" is just example, so I want to disable text/dropdown/color/toggle formatting.
I see, CustomVisual can't "disable" some formatting
I found this thread.
https://community.powerbi.com/t5/Custom-Visuals-Development/disable-custom-objects-properties/td-p/307773
maybe dm-p said also...
But can"remove" some formatting! it is nice! How can I remove the formatting parts?
HI @Anonymous,
#1, Yes, that is the official site of power bi ideas, sorry I forgot to share the link to the idea forum.
#2, These parts can be customized as the following tutorial, you not need to add all the options that raw visual defined.
Tutorial: Adding formatting options to a Power BI visual
Regards,
Xiaoxin Sheng
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
6 | |
5 | |
2 | |
2 |
User | Count |
---|---|
4 | |
3 | |
3 | |
3 | |
3 |