Forum Discussion
Different column output basing on Parameter Selection
- 1 year ago
Hi, my use case here required different solution. Anonymous thanks for this calculation I believe I will utilized it in the future. However here I got all values in one row which is not what I need.
Instead of this, I have created separate columns with calculations for day / week / month / quarter / year. Following this I have prepared separate vizuals with my required metric "Sends" (not mentioned before) on Y axis and on X axis I put my new column one by one separately for each vizual. Then I have used method described in following article to display my metric in different time-frame using buttons and bookmarks .
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Hi, my use case here required different solution. Anonymous thanks for this calculation I believe I will utilized it in the future. However here I got all values in one row which is not what I need.
Instead of this, I have created separate columns with calculations for day / week / month / quarter / year. Following this I have prepared separate vizuals with my required metric "Sends" (not mentioned before) on Y axis and on X axis I put my new column one by one separately for each vizual. Then I have used method described in following article to display my metric in different time-frame using buttons and bookmarks .
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive