Forum Discussion

supr4's avatar
supr4
Frequent Visitor
5 years ago
Solved

Can't recreate an excel graph on PBI visualization

Greeting, as mentioned above.

I'm trying to recreate this visualization, I already have the table and the slicers working.

The visualization is showing the sum of 'Tx's' per hour, and it's being filtered by 'Semana' (week) and 'Cluster'. 
I'm trying to find the way of showing the hours in the X axis, using the number of 'Tx's' as the value per hour mark.

These are the columns I have to work with.

Any hint given will be a blessing.

Thanks in advice for any answer.

  • supr4 , Based on the first excel screenshot. You need to unpivot the data, Time on x-axis and year as legend and try if that works

1 Reply

  • supr4 , Based on the first excel screenshot. You need to unpivot the data, Time on x-axis and year as legend and try if that works