Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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 ?
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |