Forum Discussion
Show hardcoded values for year 2020
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
Anonymous , I check file. Based on Intial idea.
You need measure like
if(Max('Week-month'[year]) = 2020 , [mesure from region adjust], [Other measure])
Also, check this visual might suite you need better - https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200000675?tab=overview
Hi amitchandak,
Thanks for the response. But I have tried that solution but no luck. Below is the measure that I am trying to modify
Anonymous , I think you have to use If only on week month year for value 2020 to shift measure? why you have used DISTINCTCOUNT('Segement Selection'[Segment])=1 and DISTINCTCOUNT('Region Selection'[Region])=1 ?
amitchandak , I am using Distinctcount because, I want to select only one distinct value region and if it is one then I am trying to calculate the sum(value) for that particular region. Let's say forexample if i got Region as America then I am taking total sum(value) for America. Like that I have multiple regions in my region adjust table.
Hope this will give some clarity on this requirement
Best Regards,
Srihari
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
