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. Kindly asking for help: I have a chart with x-axis as months. I want to show only 6 months worth of records here but it should be dependent on the selected slicer. ex: Selected on slicer is Sep'19 the chart should show Apr'19-Sep'19; but when we select Aug'19 on the slicer chart axis to show Mar'19-Aug'19. Hope you can assist. Thanks!
Solved! Go to Solution.
Hi @Anonymous,
You may refer to the post below to create a disconnected table for your slicer and then create a measure based on that selection.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
First you should create a calendar table and use it as a slicer, then create a measure.
1. calendar table
DimDate = ADDCOLUMNS(CALENDAR("01/01/2018","31/12/2019"),"Month - Year", FORMAT([Date],"mm - yy"),"SortMonth",FORMAT([Date],"yyyymm"))
2.use it as a slicer
3. create a measure
Sales last 6 months =
CALCULATE (
SUM ( Sales[Sales] ),
FILTER (
ALL ( Sales[Date] ),
Sales[Date] <= MAX ( DimDate[Date] )
&& Sales[Date] >= EDATE ( MAX(DimDate[Date]), -6 )
)
)
Here is the .pbix
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
First you should create a calendar table and use it as a slicer, then create a measure.
1. calendar table
DimDate = ADDCOLUMNS(CALENDAR("01/01/2018","31/12/2019"),"Month - Year", FORMAT([Date],"mm - yy"),"SortMonth",FORMAT([Date],"yyyymm"))
2.use it as a slicer
3. create a measure
Sales last 6 months =
CALCULATE (
SUM ( Sales[Sales] ),
FILTER (
ALL ( Sales[Date] ),
Sales[Date] <= MAX ( DimDate[Date] )
&& Sales[Date] >= EDATE ( MAX(DimDate[Date]), -6 )
)
)
Here is the .pbix
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks. Will surely try this.
Hi,
See if my solution here helps - Flex a Pivot Table to show data for x months ended a certain user defined month.
Hi @Anonymous,
You may refer to the post below to create a disconnected table for your slicer and then create a measure based on that selection.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks. will check this.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |