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 Teams,
I want to plot one line chart to show 3 lines on a single selection of quarter from the Date Hierarchy slicer, one line should be for current year quarter (selected quarter), another for previous year same quarter and last one for Previous quarter of the selected quarter.
For eg: An user selects Q1 2019, then the 3 lines would be for Q1-2019, Q1-2018 and Q4-2018.
On my report page there is a Date Hierarchy slicer as below
I have written the following measure to calculate the cummulative sum of revenue as below based on WeekOf Qaurter.
hi, @Anonymous
As you said, "due to slicer connection the graph only shows 1 line and filters out the others. I dont want the other 2 lines to get filtered on selection." when a user selects Q1 2019, the visual will only show Q1 2019 dim period.
Q1-2018 and Q4-2018 only will appear in Q1 2019 dim period with another line.
There is another to get it is that use an independent date table for slicer.
[SELECTED QUARTER] and [SELECTED YEAR] is based on this independent date table.
here is a similar post for you refer to:
If you still have the problem, please share your sample pbix file and expected output.
Best Regards,
Lin
Hi v-lili6-msft,
Actually my requirement is to have a line chart as below, when I select 2019 Q2 I should get three lines for 2019 Q2, 2018 Q2 and 2019 Q1. The X axis is WeekOfQuarter derived by
where
hi, @Anonymous
Could you share your sample pbix file for us have a test?
You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading
Best Regards,
Lin
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |