Reply
sirmay
Regular Visitor
Partially syndicated - Outbound

How to create vertical chart by filtering date button

Hello,

 

I am trying to create a dashboard like;

sirmay_0-1619090894340.png

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

Syndicated - Outbound

@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

 

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

Join us as experts from around the world come together to shape the future of data and AI!
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

View solution in original post

3 REPLIES 3
sirmay
Regular Visitor

Syndicated - Outbound

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.

sirmay_1-1619433499871.png

 

And I gave a try by clicking to the buttons but it did not worked. 

Charts are changing when only clicking to the bookmarks.

sirmay_2-1619433593921.png

What is the mistake here?

 

Regards,

Syndicated - Outbound

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.

sirmay_3-1619434222976.png

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..

sirmay_4-1619434307300.png

 

amitchandak
Super User
Super User

Syndicated - Outbound

@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

 

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

Join us as experts from around the world come together to shape the future of data and AI!
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
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)