Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
108 | |
108 | |
93 | |
61 |
User | Count |
---|---|
169 | |
138 | |
135 | |
102 | |
86 |