Not sure but find my approach as reference below and stored in attached workbook version 10.3 located in the original thread.
1. Parameter P1. Select
2. D0. Date (Month/Year)
3. D1. Month Year: str([D0. Date (Month / Year)])
4. D2. Make Selection:
if [P1. Select]="SelectedValue1" then [Dimension1]
elseif [P1. Select]="SelectedValue2" then [Dimension2]
ELSEIF [P1. Select]="Date" then [D1. Month Year]
5. Drag object D2. Make Selection to the indicated locations on Sheet2 and rename sheet "S1 Select". Hide Header of object D2 Make Selection in Rows
6. Drag required objects to the indicated locations on Sheet 1
7. Define Dashboard and set "Use as Filter" for sheet S1 Select
DesiDash_nalmai_10.3.twbx 23.0 KB
Thanks for your answer. I think that is not what I am looking for.
I made a printscreen. So I would like to put the calculated field that gets the selection from the select parameter into columns. When it is set on Date I would like to have the view shown below. So Year(Date) Month(Date) in columns.@
1 of 1 people found this helpful
That is a total different ballgame;).
From the "top of my head" I only can think that you can achieve this based on "Sheet-selection.
So define 3 separate sheets with the desired "lay-out" and toggle between the sheets in a dashboard based on your parameter,
But never say "could not be done". There wil always be a "bright young kid" or an "old fox" on the block who knows a "work-around";)
Thanks a million, Norbert. Then I'll wait if someones has a workaround. Otherwise I'll do it with the sheet selction method. However, due to performance I would prefer the dimension selection method.
Forgive me if I have completely misunderstood your question. But it seems you need to set up two calculated fields in the view, both looking at your parameter selection. I have attached an example workbook.
First calculated field will be similar what you have stated in your original post. Here is my version (update for your own fields):
Then your second field will be (in my example):
So this means that when anything apart from date is selected, the second value will show up blank.
With date selected:
Without date selected:
Obvs your dimension will actually have values. You would also have a line graph for the dimension values when selected, which is not ideal. Could you settle for a bar graph for you dates, so that it is also a bar when you select your dimensions (given that you don't want to swap sheets)? See below:
Apologies again if I have misunderstood.
multiple_drill_down.twbx 358.9 KB
Thanks a million Ben, that's exactly the solution I was hoping for . 100% match for my problem.
Note: I had to switch the sequenz of the Drill Levels to Drill Level 2 first and Drill Level 1 second, so that the line graph was working.
Otherwise I could just work with bars and it is not the best viz for I use about 8 different dimensions in the selector.
Nevertheless, a very solid solution for my problem.