Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
rainchong-7401
Frequent Visitor

Month does not display

Hi everyone,
Why I couldn't set all clustered column graph horizontal line Jan 2020 - Dec 2020.
It can only set Jan 2020. but In my Excel I have "Month-Year" this is to list out the month year "Jan 2020 - Dec 2020".
How come in my Power BI I couldn't pull it out ? 
Or perhaps the "Month" card visualization (top right corner) controlling the entire slicers so that Jan 2020 - Dec 2020 couldn't display?

1.PNG

2.PNG

4 REPLIES 4
v-jayw-msft
Community Support
Community Support

Hi @rainchong-7401 ,

 

As i can see from the first image, you have selected Jan in the month slicer at the top-right of the image. 

Please set it to ALL then you should be able to see values of all the months.

1.PNG

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
SivaMani
Resident Rockstar
Resident Rockstar

@rainchong-7401,

 

Sample.PNG

 

Is that your expected output similar to the above(X-axis) chart?

Sorry If I miss understood. Can you provide more details with the expected output?

Yes. Super Yes

Great.

  • Please clear the month slicer on the top right side and share the output
  • I think the first two visuals(Clustered Column chart) have Date column as Axis and the other visuals use the Month-Year column. Please try to change it to Month- Year Column like below,

Axis.PNG

Let me know if you have any issues!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.