Forum Discussion

InmaVM's avatar
InmaVM
Frequent Visitor
2 months ago

Dynamic X-Axis on Stacked Column chart (Month/Day/Hour) based on Date Slicer Selection

Hi everyone, I'm building a Power BI report and I'm trying to make the X-axis of a chart change dynamically depending on the selected time filters.   I have three slicers coming from my Date dimen...
Need Help
oussamahaimoud's avatar
oussamahaimoud
Icon for Memorable Member rankMemorable Member
2 months ago

Hi,

 

Use 3 overlaid charts (Month, Day, Hour) with these DAX measures as visual-level filters:

ShowMonthView = IF ( HASONEVALUE('Date'[Year]) && NOT HASONEVALUE('Date'[Month]) && NOT HASONEVALUE('Date'[Day]), 1, 0 )

ShowDayView = IF ( HASONEVALUE('Date'[Year]) && HASONEVALUE('Date'[Month]) && NOT HASONEVALUE('Date'[Day]), 1, 0 )

ShowHourView = IF ( HASONEVALUE('Date'[Year]) && HASONEVALUE('Date'[Month]) && HASONEVALUE('Date'[Day]), 1, 0 )

 

Filter each chart with its measure = 1 (this removes all categories, not just blanks values).

Turn OFF background, border, and title on all three (Format → General/Effects), not just transparent, fully off.

Align all three to identical X/Y/width/height.

 

With no categories + no chrome, the inactive charts render as literally nothing, so only the active one shows.