The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a lineplot which shows a value per month for 3 brands. In august no brand has any value, but I want to show this gap.
I have used "Show items with no data" option for a column from my Date Table but it did not help, the plot continues without showing August.
What can be a solution?
Solved! Go to Solution.
Good nigth @Anonymous, the best way to do this is fix your measure to show "zero" when the value is blank.
Try this:
Measure =
var Value = Table[Value]
var Validation = if(Value>0,Value,0)
return Validation
with this, if the value is blank, the measure will show zero.
Good nigth @Anonymous, the best way to do this is fix your measure to show "zero" when the value is blank.
Try this:
Measure =
var Value = Table[Value]
var Validation = if(Value>0,Value,0)
return Validation
with this, if the value is blank, the measure will show zero.
Thanks @DanielGarcia. I was looking for another solution because in this way I can not see the gaps and the lines show continuing trend.
But seems that this is the only solution up to now.
User | Count |
---|---|
81 | |
74 | |
42 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |