Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
hi
i have a line graph showing data for entire last year and current year 2 months but my current year data is displaying in right side
i am looking for data to be displayed left side below jan 2020 i want jan 2021.
Solved! Go to Solution.
Hi @Anonymous,
You can use date hieracrchy as:
Here is the output:
Best Regards,
Link
@Anonymous
Did you create a calendar table that connected with your Data table ? If no , then you need to create it. You can find million scripts to create it , if you can't find any let me know.
Then connect calendar table with your "Date" field as a key with your data table.
Then Create a measure for current year : Revenue_CY = Sum(gross_sales)
For LY you need to create a measure like this : Revenue_LY = Calculate(Revenue_CY ,sameaslastperiod(calendar[date])) or Revenue_LY = Calculate(Revenue_CY ,dateadd(calendar[date],-1,Year))
Hope that can work for you as worked for me.
Don't forget to give thumbs up 👍and accept this as a solution if it helped you.
Hi @Anonymous,
You can use date hieracrchy as:
Here is the output:
Best Regards,
Link
You need to use common Axis X for both lines. Make a chart with 2021 line only. Then create a measure for last year data (it must return Jan 2020 value if selected period is Jan 2021 and so on, you can use https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax) and use this measure for your second line.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
92 | |
82 | |
63 | |
62 | |
58 |
User | Count |
---|---|
159 | |
115 | |
103 | |
75 | |
66 |