- 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
How to create vertical chart by filtering date button
Hello,
I am trying to create a dashboard like;
I have a data set which contains, "Newsales Amount", "Increase Amount", "Renewal Amount", "Proposal Presented Date", "Close Date", "Start Date" columns. As you could see at above chart that "Proposal Presented Date", "Close Date", "Start Date" should filter the chart as a button. Stacked vertical chart includes "Newsales Amount", "Increase Amount", "Renewal Amount" as value.
Unfortunately I tried everyting to solve it but could not.
I would appreciate if you could help me.
Best Regards
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@sirmay , first of all, if you want to change axis or filter?
if the only axis, then you can use bookmark and buttons
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
if if you need measure based on date, then you need to have a date table and join that with your dates, Only one active join. Then you have to use userelationship to use inactive date join
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
Hello @amitchandak,
Thank your for the quick respond first of all!
Actually I do need only changing axis thus below link worked with me very well.
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
But I have now a problem that my buttons do not work.
I have linked Close Date button with Close Date bookmark ( At Close Date bookmark, only Close Date bar chart is unhided). Applied same step with Start Date button as well.
And I gave a try by clicking to the buttons but it did not worked.
Charts are changing when only clicking to the bookmarks.
What is the mistake here?
Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @amitchandak,
Seems that the problem is related bookmarks,
As you could see below when I click to Close Date bookmark, seems right bar chart is unhided.
But when when I click to the Start Date bookmark it shows wrong set up. There is still Close Date bar shart is unhided. I am changing it as Start Date bar is unhide. After I click to Start Date bookmark is turns back to wrong set up again..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@sirmay , first of all, if you want to change axis or filter?
if the only axis, then you can use bookmark and buttons
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
if if you need measure based on date, then you need to have a date table and join that with your dates, Only one active join. Then you have to use userelationship to use inactive date join
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
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 | |
---|---|---|---|
12-21-2022 01:14 AM | |||
08-19-2023 05:19 PM | |||
07-10-2024 08:00 AM | |||
07-12-2024 05:52 AM | |||
07-17-2024 09:45 PM |
User | Count |
---|---|
113 | |
76 | |
55 | |
54 | |
43 |
User | Count |
---|---|
183 | |
120 | |
80 | |
67 | |
57 |