Forum Discussion

epang's avatar
epang
Advocate I
1 month ago
Solved

Auto Chart refresh

Hi all, 

 

I have a new power bi report which contains and stacked column and line chart. afterthe data was manually refreshed, the value for far right column of the line y axis has disappeared. 

 

Below is the code and the chart before it is refreshed. 

 

Projected Value = CALCULATE(
    SWITCH(
        SELECTEDVALUE ('xxx View'[ Region]),
        "Barwon South West", 10,
        "Eastern Metropolitan", 24,
        "Gippsland", 10,
        "Grampians", 9,
        "Hume", 8,
        "Loddon Mallee", 8,
        "Northern Metropolitan", 22,
        "Southern Metropolitan", 29,
        "Western Metropolitan", 27
    ),
   ALl('CompletionDate'[MONTH])
)

 

Many thanks,

 

Ed

Need Help
Tips and Tricks
  • MFelix's avatar
    MFelix
    1 month ago

    Hi epang ,

     

    Without any further information is difficult to pinpoint what can be happening this can result from a number of questions that can be related with the semantic model and refresh question or with the setup of the visual itself.

     

    I would advise:

    • Check if the data exists in the semantic model table xxx View column region
    • If you have value check if there wasn't any change to the values since you are hardcoding them in the measure any changes to the original values will return blank
    • Check if there are any filters applied to the visualization that are impacting the visualization

    Any other pointers are difficult without further context, so if you need any assistance let me know.

5 Replies

  • MFelix's avatar
    MFelix
    Super User
    1 month ago

    Hi epang ,

     

    Without any further information is difficult to pinpoint what can be happening this can result from a number of questions that can be related with the semantic model and refresh question or with the setup of the visual itself.

     

    I would advise:

    • Check if the data exists in the semantic model table xxx View column region
    • If you have value check if there wasn't any change to the values since you are hardcoding them in the measure any changes to the original values will return blank
    • Check if there are any filters applied to the visualization that are impacting the visualization

    Any other pointers are difficult without further context, so if you need any assistance let me know.

  • AnkitKukreja's avatar
    AnkitKukreja
    Super User
    1 month ago

    Hi! epang 

     

    I would check this in Desktop to see if it is reproduceable, if yes then I would check the power query editor to see maybe for 1 region if data is available or not, seems like a data issue as Power BI won't change anything (AI is available but not so advanced as of now 😂)

     

     

  • v-aatheeque's avatar
    v-aatheeque
    Community Support
    1 month ago

    Hi epang 

    Just checking in could you please share the requested sample data and expected output? Once we have that, we'll be happy to investigate further.

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      1 month ago

      Hi epang

       

      We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know