How to show all X Axis disregard the selection

[KH_Mike]

Hi All,

I have a data which contain Year, Month and other column. The dataset accumulate around 3 year till 2021-08. I also have a "Slicer" for the Year. Now, I create a Line Chart and would like to show all Month disregard the "Year" selection. That mean, even I select 2021. It will also show all the month from Jan - Dec. May I know is it possible to do it? Thank you.

[Ashish_Mathur · Accepted solution]

Hi,

Create a Date column in your dataset.  Create a Calendar Table till 31 December 2021.  Establish a relationship from the Date column of your Dataset to the Date column in your Calendar Table.  To your slicer, drag Year from the Calendar Table.  To the x-axis of your other visual, drag Month name from the Calendar Table. 

[Greg_Deckler]

@KH_Mike Use a disconnected table for you axis. You will need to adjust your measure/aggregation accordingly.