Create a slicer that displays a bar graph over time

[bobbob123]

Hi all,

I have the following data on excel which analyses team perofmrnace over time.

When I upload this on Power BI, I can see all my teams and their performance yearly.

I'm finding it hard to create a slicer so that I can select my year and team and observe their performance.

[v-chenwuz-msft · Accepted solution]

Hi @bobbob123 ,

In power query editor, select the [Team] Column and unpivot other columns.

Then result:

bix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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

[amitchandak]

@bobbob123 , I would advice to unpivot the year and bring them into rows.

https://radacad.com/pivot-and-unpivot-with-power-bi

Otherwise create measure for each year and then create calculation group

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0

[bobbob123]

Can you show me how to unpivot the year and bring them into rows? I'm new to POWER BI.