Erased

[gnavia]

<

[Greg_Deckler]

@gnavia - I downloaded your file and I would highly recommend starting by unpivoting all of your humidity and temperature columns. Beyond that, I am not 100% on what you are trying to achieve. 

[gnavia]

Hello @Greg_Deckler , thank you for your response. I don't know what you mean by despivo, maybe it means depivot?, but if I do that I'll lose the date ratio with the columns. What I'm trying to achieve is to filter the graphs so that it only shows 1 or 2 humidity values to compare and not all, the same with the temperature. Other than that if I convert the columns into rows, as I mentioned earlier the date relationship to the data would be lost.

[v-lili6-msft · Accepted solution]

Hello @gnavia

I don't know what you mean by despical, maybe it means depivot?

This means that you collapsed the fact data table, please refer to this blog:

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

Best regards

Lin

[gnavia]

Hello

I try to do what you tell me, however I get the following error:

I get an error due to duplication of dates in the data because I have pivoted the columns

[v-lili6-msft]

hi @gnavia 

This error is that you need to delete the relationship, then unpivot the table and then close&apply.

Regards,

Lin