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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Arranafc19
Helper IV
Helper IV

Not Displaying Values on Chart

I am working on a power bi line chart and I want to exclude records from my line chart without changing the values by doing so.

 

I have a dataset which gives me a number of products and the month in which they were sold. When I put this into a table and display the number of sales per month as a percentage I get the below with the "Null" value being the items that are not sold.

Screen Shot 2019-06-20 at 20.22.33.png

I need to be able to display months 1-12 on a line chart , not displaying the null however using them for the overall percentage total. When I filter to show only where month > 0 , I am excluding the cases with no sale date from the percentage calcualation and they all rise. Is there a way to display this on a chart , and just not show certain values ?

17 REPLIES 17

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.