How can I make a box like the example below with each year from my data serie?

[TheUnknown]

How can I make a box like the example below with each year from my data serie? I want to visualize the data for the year that is selected and do not want to visualize for the year that isnt

Ex:

Chart:

Data:

Thanks!

[parry2k]

@TheUnknown First you need to reshape your data, pivoted data is not a good format for BI. Here is what you can do to unpivot it:

Transform Data -> Select all columns except year columns -> Right click -> Unpivot other columns

It will create two columns called Attribute and Value, rename as you see fit, attribute will contain year column, close and apply.

Now you can use the month column on the x-axis and value on values and year as a legend and that will do it.

As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel

Add Date Dimension
Importance of Date Dimension
Mark date dimension as a date table - why and how?
Time Intelligence Playlist