Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello guys,
I have some key figures, which have been measured about one year after the first date of the existing dataset. So if I use a line chart, the Y-Axis scales with the first existing value which is not null. So one visual shows the line chart from 2020 till 2021 and the another line charts are showed from 2019 till 2021.
So i puted on this Measure for the key figure: [Key Figure] + 0 to put the null values as 0 values, so the X-Axis from the key figure scales from 2019 till 2021.
But if I put the slicer from 2020 till 2021, they X-Axsis is still showing 2019 till 2021 and is not scaling with them.
Here two pictures:
Here you can see the zero values to scale the left visual.
And here you can see, that the left line chart isnt scaling anymore with the slicer, it only puts the values which are not in this time intervall to zero values too.
Is there any solution for this?
Thanks in advance!
Solved! Go to Solution.
@Clout , Try to control impact of +0 using a measure like
0 between range
Measure = var _1= SUM(Opportunity[Opportunity count]) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))
@Clout , Try to control impact of +0 using a measure like
0 between range
Measure = var _1= SUM(Opportunity[Opportunity count]) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))
Great, thank you very much!
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
177 | |
85 | |
70 | |
63 | |
55 |