Forum Discussion

BigKev's avatar
BigKev
Helper III
1 year ago

Discrepencies between visualisation type

Hi All,

 

Something weird appear on my visual.

 

This is what the data looks like when I use table view

However, when I change the visual to Tabular/ Line chart, it seems like the Month Name is shifted -1.

For example, when I hover on July’s bar, it is showing June data (as shown in the tooltip).

 

Hence the last bar chart has not month name, as it supposed to be Nov-24

 

 

There are no complex calculations measure for this, as the number is coming from one table.

I am also using the default PBI visuals and not custom visuals.

 

Does anyone have any idea why this happened? And how to fix the visual chart

 

TIA.

Need Help

3 Replies

  • SamWiseOwl's avatar
    SamWiseOwl
    Super User
    1 year ago

    Hi BigKev 

    Do you have any filters on the X or Y axis?

    Under the settings in the Visualisation pane.

     

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    1 year ago

    very odd, dont suppose you can share your pbix.  

     

    What might help is creating an explicit measure rather than implicit if you haven't 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi BigKev ,

    I can't reproduce your problem with the latest version of Power BI Desktop. What's the version of your Power BI Desktop? How do you set the column chart(Fields settings)? 

    Best Regards