Dinamic bar chart dependent on slicer button

[jorgeiuc]

Hi Guys!

I am pretty new using power BI so the task that I was requested to do might by a bit advanced to my current level, that's why I appreciate any advice.

I have a table with dates and the number of time an equipment is loaded per day so I would like to show a bar chart with the info of the last 7 days, so when I select a new date on the slicer button the chart update.

So far I've been able to get it done however the slicer is not link to the rest of the info on the report and it only update the chart but not the rest of tables,

Thanks in Advance!

[KNP]

BI Elite has some good demos on this topic.

https://www.youtube.com/c/BIElite/search?query=dynamic%20chart%20with%20slicer

I'm not sure I fully understand your scenario, may need some screen shots and data to be able to better help.

[jorgeiuc]

Thanks for your reply!,

Actually, I'm trying to replicate this report on BI

So everytime a different date is selected the bar chart changes showing the last 7 days since the date selected, meanwhile the table has the info of the day.

Here is part of the data I do have 

The left bar chart has the total amount of "cps" per day,

I hope I explained myself a bit better, Thank you.

[Ashish_Mathur]

Hi,

See if my solution here helps - Flex a Pivot Table to show data for x months ended a certain user defined month.

[KNP · Accepted solution]

That makes more sense. I don't have time for a detailed reply just now but I think you could adapt one of these to what you want.

https://www.youtube.com/watch?v=duMSovyosXE&t=565s&ab_channel=BIElite

https://www.youtube.com/watch?v=MooZofz5GOI&ab_channel=EnterpriseDNA

[jorgeiuc]

Thank you! I will give it a try.