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.
I promise I tried everything, but couldn't figure out how to get the 'sliding scroll bar' to display the latest data when the visual complied; instead, the user has to drag the slider 20+ years worth of monthly data to see the latest figures.
Is there a way to have this reversed (WITHOUT reversing the values and having the latest year all the way to the left and the oldest to the right, as "we" read left to right and used to looking all the way right for the latest data). 🙂
Is this possible?
Here's what you see when it compiles (Boo!):
Here's what I would like you to see without having to scroll 20+ years (Yea!):
Hi, @Terp ;
As parry2k said, this is impossible. however, You could do it by slicer, as follows:
1.enter a slicer:
2.create a measure:
Measure = IF(ISFILTERED(SLICER[slicer]),SUM([Value]),CALCULATE(SUM([Value]),FILTER('Table',[Date]>=DATE(2019,5,1))))
By default, the chart displayed is the data after May 1, 2019. If I choose the slicer, it will display all the data:
In addition, you mentioned that you want to highlight the data for March 2021, you can set it in visualization->format->data color.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous is that a question for me? Everytime you are posting on a post, please tag the person. Just a suggestion.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
And sorting years descending?
@Terp highlighting is not going to solve the scroll bar issue. For the month column you are using on x-axis, add another column in the table as a date with the value as the end of the month, and then use it on x-axis
If month Jan 1999, the new column will be the date as 31st Jan 1999, so the last date for each month and make sure change x-axis to continuous, that will fix it.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Figured out how to highlight a bar by default (sort of), but same result....user has to scroll through 20+ years of (unhighlighted) monthly data until they see the highlighted bar/values. 😢😢😢
How about this—having the most current month highlighted/selected in the chart? (i.e., the default state of the chart is to have March 2021 highlighted)
@Terp unfortunately that is not possible, it is always going to show the starting point. There is no functionality out of the box to achieve this.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |