Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am trying to plot a line on this line chart for Prior Year (same month previous year). But it doesn’t work on this chart. I just get 1 dot for the filter i choose. It is suppost to exclude the month filter and give the whole year plot. My Expense & Budget data is aggregated monthly, i do not have daily data.
If I use table, i should get the whole list but i didn't.
My formula are chart are
Other related formula are
This is the design of the data model
Thank you.
User | Count |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |