Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear Team
I have a line chart which consits of 365 days data , now i would like to limit only 12 days in power bi.
note:( even i have slicer selection for one month for eg jan1 2022 to feb 1st 2022 ,
the line chart has to be display only 12 days from the jan1st 2022)
can we limit the xaxis to only 12
Regards,
Dharanidhar
@dharani7 , Use a measure like this in visual
new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = _max -12
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))
thanks amit but i am using url filtering all the slicers are embeded from front end (angular) ,
does this work?
Hi @dharani7 ,
Dynamically limit 12 days, it doesn't seem to work. It is also recommended that you create visual-level filters in the report.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |