Forum Discussion
Helper IIDifferent column output basing on Parameter Selection
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
Helper IHi Szokens,
Instead of creating parameter, create table using Enter Data. Do not create any relationship for that table. Just put the column from Enter data table in a slicer. Apply business logic in a measure using SWITCH funtion.