cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ANKITBISANI
Advocate I
Advocate I

Dynamically Changing X Axis with respect to the Slicer Value Selected

WhatsApp Image 2017-09-15 at 12.47.01 PM (1).jpegWhatsApp Image 2017-09-15 at 12.47.01 PM.jpegHi Experts,

 

I have Date Dimension with attributes DateID,Date,Month,Quarter,Year.

Fact table: DateID,SalesValue.

 

My report has 4 slicers: Year. Quarter, Month, Day.

I want to plot bar graph for SalesValue Vs Time Component (May be Year ,QTR anything)

 

Time component would be dynamic .

Meaning :

 

When I select 2017 from Year slicer ,my bar graph on x-axis should show up 4 Quarters for 2017 Vs SalesValue.

Similarly, When I select Quarter the x-axis should dynamically switch to months of those quarter.

Any help or workaround would be appreciated.

 

Attached Image shown the scenario . As year is selected from slicer ,it shows Quarter and with quarter , it shows up month.

 

Also , we are referring the below link but the issue seems to be differnt .Here I need to select a value from slicer wheras below link only shows about the attribute from the slicer I select .Ex Year ,Month

 

https://community.powerbi.com/t5/Desktop/Dynamic-change-in-X-Axis/m-p/87174#M36525

 

Thanks

 

 

2 REPLIES 2
Phil_Seamark
Microsoft
Microsoft

Hi @ANKITBISANI

 

Here is one way you can do it.  I have created a simple PBIX file that you can download to see how it it works

 

https://1drv.ms/u/s!AtDlC2rep7a-n1mIeiBbW3A4gMmL

 

View report online

 

I might write this up in a blog post tomorrow and update this post with a link

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Hi @Phil_Seamark,

I also got the same issue.Thanks for your post.

 

The pbix uploaded by you has Data table at Day, Month,Quarter and Year level. And date dimension has only one column.

What if I have only DayID in fact table.How to get then dynamic measure on month,year and quarter level?
Or Is it necessary to have Day,Month,Quarter,Year in the fact table to use USERRELATIONSHIP for calculation.

Is there any workaround if I have only DayID and MyValue in fact table?

 

Thanks  

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors