Forum Discussion

Lucy01's avatar
Lucy01
Icon for Helper II rankHelper II
15 days ago

Data Not Displaying When Selected

I have a month over month matrix that compares sales and I use a slicer to filter it by area, e.g London, Cardiff, Edinburgh. It was working perfectly to begin with, but after a recent refresh, it n...
Need Help
Lucy01's avatar
Lucy01
Icon for Helper II rankHelper II
13 days ago

I've since found that this happens with another Area as well (Glasgow) so as a test I removed all data from my spreadsheet besides London & Glasgow. The London data displayed in the month over month chart, but Glasgow returned no values.

I've trimmed & cleaned the text and made sure the casing matches. I can't find any discrepancies in the data, but I'm not sure why it isn't displaying accurately

Suggestions welcome, thank you

  • v-aatheeque's avatar
    v-aatheeque
    Icon for Community Support rankCommunity Support
    7 days ago

    Hi Lucy01​ 

    Thanks for the additional details. Since the issue now affects both London and Glasgow, and you've already cleaned the text values and verified the relationships, I'd suggest checking the month-over-month measure and its date context next.

    Could you try adding your basic Total Sales measure to the same month-over-month matrix alongside the existing measure? This will help determine whether the issue is specific to the month-over-month calculation or affects the underlying sales values in that visual as well.

     

    • v-aatheeque's avatar
      v-aatheeque
      Icon for Community Support rankCommunity Support
      5 days ago

      Hi Lucy01​ 

      Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.