Forum Discussion

Szokens's avatar
Szokens
Helper II
1 year ago
Solved

Different column output basing on Parameter Selection

Hi Guys and Welcome Everyone! my first post in this community :).   I have following query. I have created parameter using "New Parameter" -> "Numeric Range"   Then I have edited parameter ...
dynamic values
formulas
parame
parameter
parameters
  • Szokens's avatar
    Szokens
    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 

ValtteriN's avatar
ValtteriN
Community Champion
1 year ago

Hi,

The issue is that you are trying to use this as a column. If you place the dax into a measure your logic should work. I re-created this with test values:

Parameter = DATATABLE("a",STRING,{{"a"},{"b"}})
Measure 31 = SWITCH([Parameter Value],"a",1,3)

 

On a separate note what you are doing here doesn't really have anything to do with parameters. While you created the template for your calculated table and SELECTEDMEASURE calculation with it this is a separate topic.


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/