Forum Discussion
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 ...
You can use the same measure for both.
Click the chart, and on the right, select month (or add it if needed) in Visual level filters > Advanced Filtering > Show items when the value: is not blank > Apply Filter
Cmcmahan if I do this , will this alter the percentage values by excluding the values ?
Basically I need to get the percetage of sales that are completed by month of the overall total. If I use the filter , I will be excluding the ones that havent sold which will affect my percentages.