Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Show hardcoded values for year 2020

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi v-jingzhang and amitchandak, thanks for your time and the response. I have got the solution and now i can able to show those values in my chart.

     

    Best Regards,

    Srihari

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Anonymous 

It seems the issue is in the variable plug_year in measure VPY_Selected. Currently the result of plug_year is always blank because its if statement will never be true. To me, DISTINCTCOUNT('Region Selection'[Region]) and DISTINCTCOUNT('Segement Selection'[Segment]) are always greater than 1, so it doesn't calculate for 2020 values. Maybe you can first consider modifying the measure to meet the columns chart's requirement? It seems this chart doesn't need to consider Region and Segment?

 

Regards,
Community Support Team _ Jing

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi v-jingzhang and amitchandak, thanks for your time and the response. I have got the solution and now i can able to show those values in my chart.

 

Best Regards,

Srihari