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,
i am applying a page filter to the Calendar table.
I would like to display visuals which partially ignore the filter applied to the date, so that, for example, I can select September (single month) and see in the visuals all the sales by month till September (with the X axis showing each month, not only September)
So summarizing how I can have a x axis which is not impacted by page filters applied to the same column of data?
thanks
Luca
Solved! Go to Solution.
@LucaA I suggest you to create a YTD measure of the value you want to show in the chart and then use that measure in your chart
1. You can create YTD measure, using the New Quick Measure option.
Proud to be a Super User!
Tricky to do that exactly, but have you tried using an advanced filter on your Date column with is on or before and the date picker?
Otherwise, I think you will need a disconnected table with your month values and/or need to build the logic into your measures.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
ty @mahoneypat but the user should be allowed to change the reference month.
Which is the best option between the 2 suggested (disconnected vs measure)? can you explain each one/the best ?
thanks
Luca
@LucaA I suggest you to create a YTD measure of the value you want to show in the chart and then use that measure in your chart
1. You can create YTD measure, using the New Quick Measure option.
Proud to be a Super User!
TY @negi007 . the output looks perfect.
Just 2 questions:
1) TOTALYTD should not give me the YTD value? (so if Jan is 1 and Feb is 5, in Feb i should have 6)
2) So the trick is to create another column for the month (i already have one) in the same date table, why? i dont understand
thanks
Luca
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |