Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have a line chart with Number of sales by month, but the table does not show the monhs in which there is no data.
Solved! Go to Solution.
Hi @Anonymous
To show the months without data, you can click on axis X and check the option: " Show items with no data".
Please refer to the attached picture:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @Anonymous
To show the months without data, you can click on axis X and check the option: " Show items with no data".
Please refer to the attached picture:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @Anonymous
In this context, it's not 0....but you don't have any data.
If zero is mandatory, then you need to build a measure with dax manipulations so that there will be zero in months with no activity.
Please post a separate question with an example of your data tables and a measure you calculate
With a simple measure, e.g., calculate sum(sales['Sales']), should not it give me zero for month in which there are not sales?
when I use a measure of this kind:
var result = calculate(sum(Sales['Sales'])
return
if(result = 0, "1000", result)
it gives 1000 for months with zero sales, so it sees them as 0, and not blank, is that right?
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.