Showing results for 
Search instead for 
Did you mean: 
New Member

Conditional formatting on data type in chart



In my report I have a bar chart which shows values which are dependent on which category you choose in a filter. However the values are always shown in one format, based on the data type.

Is there a way to format some values (dependent on which category you choose) as a percentage and others as a whole number for instance?


Or is the only way to split up the data in your datamodel in two fields? (one formatted as percentage, the other as whole number). However this would mean I cannot use one datafield for the chart and one filter.. 


Hope somebody has an idea! 


Many thanks in advance!



Super User IV
Super User IV

Re: Conditional formatting on data type in chart

Hi @maxderuijter 


Please can you provide a data sample and the expected outcom.

The below will help you get your question answered quickly, please read it.


Best Regards,

Please feel free to connect with me.
Mariusz Repczynski


New Member

Re: Conditional formatting on data type in chart



He probably meant something like this:


DESCRIPTION                                                             TYPE            VALUE
Average # services per case (excluding info cases)      #              0.482515549
Average # services per case (excluding info cases)      #              0.403145397
Average # services per case (excluding info cases)      #              3.088306458
ROS rate                                                                       %              0.732774807
ROS rate                                                                       %              0.726065676
ROS rate                                                                       %              0.739737388
ROS rate                                                                       %              0.724623188


So, the question would be, how to conditionally change the data type for the values of "value" depending on the character of the column "type".


Thank you

Helpful resources

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.



Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors