Help : Slicer & Graph

[RENJITH_R_S]

Hello friends

I have a requirement like 

Week No

Week 32

Week 31

Week 30

Week 29

Week 28 & so on

I m using this week no as a slicer

I m ploting a bar graph with this Week No as axis & another column with values

my requirement is if i m selecting week 32 on slicer graph needs to show week 32 , week 31 & week 30 in the axis with its values

similarly if i m selecting week 31 on slicer graph needs to show week 31 , week 30 & week 29 in the axis with its values and so on 

Please help on this

[amitchandak]

@RENJITH_R_S , For that you need an independent week table also.

refer this video - same approach you have to follow

https://www.youtube.com/watch?v=duMSovyosXE

[RENJITH_R_S]

thanks @amitchandak 

[v-kkf-msft]

Hi @RENJITH_R_S ,

You need to create a separate table that contains the Week No column and apply it to the slicer.

Then create the following measure as value of the bar chart.

Measure = 
var selectvalue = 
  RIGHT(
    SELECTEDVALUE('Slicer Table'[Week No]),
    2
  )
var tab =
  FILTER(
    'Table',
    RIGHT( 'Table'[Week No], 2 ) in {selectvalue,selectvalue-1,selectvalue-2}
  )
return 
  SUMX( tab, 'Table'[Value] )

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RENJITH_R_S]

@v-kkf-msft Thanks for the response. This is my requirement, but i m not able to acheive it by your solution. Can you share your pbix file. I followed your steps but for me only selected week value is showing , other 2 values not showing

[v-kkf-msft · Accepted solution]

Hi @RENJITH_R_S ,

This is my PBIX file.

https://microsoftapc-my.sharepoint.com/:u:/g/personal/v-lazhang_microsoft_com/ESF9taOGrPFCvXG7qGqSxZ...

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RENJITH_R_S]

@v-kkf-msft Thanks