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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

"Negative values" message in piechart where content is zero

I have a piechart where (due to filtering) all content adds up to 0. This gives me an exclamation point in the top left, with the message "Negative values aren't supported and are being displayed as absolute values". The content is 0, so I get an empty piechart (as expected). But is there a way to get rid of this message? I think it might be confusing to some of our users.

 

2019-02-14 11_31_10-mOp vestigingsrapportage - Power BI Desktop.png

In this screenshot I recreated the situation with 2 calculations which are both 0 (IamZero = 0, Iam0 = 0).

4 REPLIES 4
parag_lokare
Advocate I
Advocate I

We have a report with new measure to count distinct "meaure=distinctcount(Tab[col])". We want to display 0 instead of "Blank" on the CARD hence we added +0 to the measure equation "meaure=distinctcount(Tab[col]) +0". it works great on the card. But when this measure is put on the pie chart and when there is no data, It shows the error. We decided to create a new measure without the +0 and use it on charts. The other workaround is do not use any measure, and directly use the column and with count distinct from the value agreegation

v-lili6-msft
Community Support
Community Support

hi, @Anonymous

After my research, It is a reminder of the visual and we could not remove it for now.

But as a workaround, if "some of our users" do not have edit view in power bi service, you could try this way:

Click File->Options->Report settings->Hide the visual header in reading view

Enable it and republish it to power service.

14.JPG

Result:

Eidt ViewEidt ViewRead viewRead view

 

 

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thanks for your reply! Unfortunately we do have some visuals where useres should be able to export the data, which is why we cannot hide the visual headers. Do you know whether there is another workaround?

hi, @Anonymous 

If so, I'm afraid it couldn't achieve in Power BI for now.

For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner .

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.