Data Visualization

[Crisomac19]

Hello!

I need help with the data it appears on my Stacked Column Chart. I working with a company income data (March tu June). If i only show the income data I get only the info of the months with data, but when I add a line y-axis to record the month to month chage, i get an extra month (July) which i have no data yet. Is there a way to not show july, or any month where data doesn't exist?

Also, as you can see in the image bellow, even dow i have a positive increase from april to may, it may appear from the line that it decreased. Is there a way to correct the slope?

Thank you in advance for any help I can get.

[Ashish_Mathur]

Hi,

Assuming the Month names on the X-axis have been dragged from the Calendar table, ensure that the last date inthe Calendar Table is till the last day of the current month.

[mahenkj2]

Hi @Crisomac19 

1. You can use a slicer on top to able to avoid latest month for which data is not available.

2. Use a DAX measure with IF THEN ELSE condition to check if column data is available or not.

Hope it helps.