Forum Discussion
belli
5 years agoNew Member
Dynamic Period vs. other Dynamic Period
Hi! I'm trying to compare two dynamic periods that the user can select with a slicer : As a rusult, I would like to have a visual to compare this two periods (hier I have 2 years but I wou...
- 5 years ago
belli , refer this blog, one slicer need to be independent
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Greg_Deckler
5 years agoCommunity Champion
belli - If I am reading correctly, columns are not dynamic based upon user interaction, they are only calculated when you refresh/update the data. You need to use measures for this.
belli
5 years agoNew Member
Hi Greg_Deckler , as I understand it correctly, I can not calculate the value for each row in the table depending on the parameter (slicer). Right? Thank you for your sugestion, Mesure is not working in this case, because i need the value for each row, like Day or Week or Month etc.