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 September 15. Request your voucher.
Hello,
I use several constant X-axis lines to highlight a date range, but the problem is when I filter by date. it yields a result with empty areas and the constant lines always there :
there's a way to fix this?,
thank you !
Solved! Go to Solution.
@mouhsinebella , You can use a measure in Constant line , so try a measure like
if(date(2020,06,01) >= minx(allselected(Date), Date[Date]) , date(2020,06,01) , blank())
@mouhsinebella , You can use a measure in Constant line , so try a measure like
if(date(2020,06,01) >= minx(allselected(Date), Date[Date]) , date(2020,06,01) , blank())
User | Count |
---|---|
70 | |
64 | |
62 | |
49 | |
28 |
User | Count |
---|---|
117 | |
80 | |
65 | |
54 | |
43 |