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
Best Regards,SriAnonymous , 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