Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
HI All,
I have a line graph which has some values shown as data labels, i would like to conditionally format these labels. Can anyone help?
Solved! Go to Solution.
Hi @Anonymous ,
You cannot condittional formatting data labels however you can make a work around:
Create 3 measures:
Total Values = SUM(Table[Column])
Total Values Above = IF([Total Values] < 100; BLANK(); [Total Values] )
Total Values Below= IF([Total Values] < 100; [Total Values] ;BLANK())
Now add your measure to the line chart and make the following setup:
Turn of the lines on the Values above and below
Turn off data labels on the Total Values measure
Make different formatting for labels for lines above and below
Adjust the measure to what you need if you want to have additional levels you need to create additional measures.
Check PBIX file attach.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI sympathize with this issue. Here's an example. Data labels for certain values can show up as 0.0K, but having all data labels in raw units just looks crowded (ie. 4.2K > 4,200 and 144 > 0.1K). There should be conditional formatting for units as there is for color.
I submitted an idea ticket: https://ideas.powerbi.com/ideas/idea/?ideaid=10ba158d-4e13-ed11-b5cf-281878bd0909
Hi @Anonymous ,
Have your problem be solved? Please consider accept the answer as a solution if it worked.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You cannot condittional formatting data labels however you can make a work around:
Create 3 measures:
Total Values = SUM(Table[Column])
Total Values Above = IF([Total Values] < 100; BLANK(); [Total Values] )
Total Values Below= IF([Total Values] < 100; [Total Values] ;BLANK())
Now add your measure to the line chart and make the following setup:
Turn of the lines on the Values above and below
Turn off data labels on the Total Values measure
Make different formatting for labels for lines above and below
Adjust the measure to what you need if you want to have additional levels you need to create additional measures.
Check PBIX file attach.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsStarting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
60 | |
57 |