March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I am trying to create a line chart that varies with slicer selected. Let me explain briefly
I have created measures as follows:
Hi,
Share some data and show the expected result. As of now, don't bother about the visual. For the data that you share, just show your actual expected result in a Table. Once the numbers in the Table appear OK, we can alsoways switch to any visual.
Try like this.
These formulae will change based on the slicer. the date is date dimension here.
Sales 12 month = ( VAR _Cuur_start = Maxx('Date',dateadd('Date'[Date],-12,MONTH)) VAR _Curr_END = Max('Date'[Date]) return calculate(sum(Sales[Sales Amount]),Sales[Sales Date] >= _Cuur_start && Sales[Sales Date] <= _Curr_END ) ) Sales 3 month = ( VAR _Cuur_start = Maxx('Date',dateadd('Date'[Date],-3,MONTH)) VAR _Curr_END = Max('Date'[Date]) return calculate(sum(Sales[Sales Amount]),Sales[Sales Date] >= _Cuur_start && Sales[Sales Date] <= _Curr_END ) )
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
@amitchandak Did not work. When i selected august the line chart shows values as dots, where as i wanted the line chart to display march to august in X axis and every month show 3 months average
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
87 | |
86 | |
75 | |
49 |
User | Count |
---|---|
164 | |
149 | |
101 | |
73 | |
56 |