Forum Discussion
Erased
<
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
5 Replies
- Greg_DecklerCommunity Champion
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.
- gnaviaHelper I
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-msftCommunity Support
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