Auto Chart refresh

[epang]

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

[v-aatheeque]

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]

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

[AnkitKukreja]

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 😂)

[MFelix]

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.

[123abc]

can you please share your sample file ?