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
Mounika09
Frequent Visitor

Irrespective of filter x-axis should be in same line for all visuals.

@PBCommunity 
I have created 2 visuals and arrange in top and bottom with the Same height, X axis and Width. When i am trying to apply the filter for these two visuals (for two visuals i am applying visual level filter) x axis alignment is changing like below.

Mounika09_0-1624268279042.png

Is there any way to give fixed alignment for x-axis irrespective of filters?

 

More info:

Different filters are applied for these two visuals example: First visual is showing for one division and another visual is  showing for one division.

If i remove the filter for second visual x-axis alignment will be same however if i apply filter on it showing wrong alignment.

 

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @Mounika09 ,

 

Your issue is that you don't have values for april in the bottom chart that is why the two visualizations are not matching you can do one of two options:

 

  • On the X-axis turn on the options show items with no data
  • If you are using a measure try to use coalescence to return 0 instead of blank
Measure = COALESCE (SUM(Table[Column]), 0)

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

5 REPLIES 5
v-yalanwu-msft
Community Support
Community Support

Hi, @Mounika09 ;

Have MFelix’s reply helped you to find the solution to this problem? 
If so, would you like to mark your own reply as a solution so that others can learn from it and close this topic?
If not,could you share file without any sesentive information.
Thanks in advance!

 

MFelix
Super User
Super User

Hi @Mounika09 ,

 

Your issue is that you don't have values for april in the bottom chart that is why the two visualizations are not matching you can do one of two options:

 

  • On the X-axis turn on the options show items with no data
  • If you are using a measure try to use coalescence to return 0 instead of blank
Measure = COALESCE (SUM(Table[Column]), 0)

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Hello MFelix,

 

I do have data for all months except June in both visuals. I tried with your suggested measure as well however i am getting same issue.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Hello MFelix,

I will send Sample data to you

 

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.