Forum Discussion
How to show null values when in data table there's no such data
Hello! I am working with a report where in the data the values with 0's aren't included in the data table. My problem is that I must portray in graph's also the 0 values. Here is a much simplifi...
Shaurya
Memorable Member
Memorable MemberHi ievazal,
Well in that case there has to be a list of all the countries and products. Since a 0 value means that there is no row for that combination of Country and Product, there should be a dimension that still has those names listed. In that case we can write formulas that check whether there are countries and products that do not have any value.
Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Graphical Comparison
Any advice on what formulas I could use? Should I use M code for it? IF statements? I am a beginner, only know the absolute basic DAX, so trying to think about the formula to use for this breaks my brain