Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a requirement to compare last year data with current year data with a line chart and show the differentiation using background color shading. For ex, all the months in the last year 2020 should have a background shading with one color and current year 2021 with a different color shading. Sample attached. If exactly the same is not possible then, any other closeby ideas also appreciated.
Thanks
Raj
Hello,
Thanks for your reply. I have tried the X-Axis Constant line and I got the background shade for the last year. I am looking for 2 lines with the current year and last year but I am missing all month's information on X-Axis. I have attached the latest screenshots.
When I apply Type Continuous, I am able to see the background and missing Feb 2021 on X-Axis.
When I apply Type Categorical, I am able to see All month's information but not the background.
Please let me know if I missing anything here.
Thanks,
Rajesh
Howdy, I'm please it worked 🙂
That is expected behaviour for continuous axes, as they are continuous, there is no need to plot all values, especially if it is a measure that can be split into fractions.
Data: Continuous vs. Categorical (eagereyes.org)
You should be able to add a second constant line on a continuous axis:
and then add shade after
Proud to be a Super User!
Hello,
You can do this with the X-Axis Constant line:
With the in-built line visual, in the Analytics Pane:
Add a line, set the date hardcoded or using a formula.
Add shading and data label.
Let me know how you go 🙂
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |