- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Moving X axis based on Month selected
I am trying to create a line chart that varies with slicer selected. Let me explain briefly
I have created measures as follows:
I can provide sample PBIX file if that would make life easy.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
Online Event
Register Here
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
07-16-2024 02:55 AM | |||
05-06-2024 09:50 AM | |||
01-19-2024 12:44 PM | |||
07-12-2024 02:32 PM | |||
11-15-2023 11:57 PM |
User | Count |
---|---|
127 | |
81 | |
59 | |
58 | |
44 |
User | Count |
---|---|
182 | |
114 | |
82 | |
67 | |
52 |