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.
Hi
I have created a line chart where it can compare the trends for 2 years.
For this line chart, I want it to remain trending for 2 years without changing either if I choose any reporting year.
How can I do this?
For Axis fields I selected = Reported Date
For Legend fields I selected - Reported Date and change it by date hierarchy
For the Value fields I created a measure =
Solved! Go to Solution.
Hi Zaky, you can disable the effect of the year slicer on that visual.
You can then either filter your visual manually to the years you want using the filter pane, or do this dynamically.
Assuming you have a column for year in your table which you're using for your legend, you could use something like this to filter your measure to current + previous year.
Measure = //create variable to store current year Var CurrentYear = year(now()) RETURN if(max('Master'[Year]) in{CurrentYear,CurrentYear-1},CALCULATE(COUNT('Master'[Incident ID]))) |
Hi Zaky, you can disable the effect of the year slicer on that visual.
You can then either filter your visual manually to the years you want using the filter pane, or do this dynamically.
Assuming you have a column for year in your table which you're using for your legend, you could use something like this to filter your measure to current + previous year.
Measure = //create variable to store current year Var CurrentYear = year(now()) RETURN if(max('Master'[Year]) in{CurrentYear,CurrentYear-1},CALCULATE(COUNT('Master'[Incident ID]))) |