-
1. Re: Multi- Select Dimensions as Filters in dashboard
Vikram GokhaleJan 11, 2019 12:39 PM (in response to Chaitanya Khurana)
Can we list dimensions on one single select dropdown parameter and measures in another single select parameter and use two calcs that reference the selected parameters to create the needed cross tab ? Sorry, could had sent a sample, but I am travelling ..
-
2. Re: Multi- Select Dimensions as Filters in dashboard
Shinichiro MurakamiJan 11, 2019 4:27 PM (in response to Chaitanya Khurana)
Hi Chaitanya,
Please attach mocked up sample data as twbx and illustrate your expected view.
Thanks,
Shin
-
3. Re: Multi- Select Dimensions as Filters in dashboard
megha gawali Jan 16, 2019 1:14 AM (in response to Chaitanya Khurana)Hello Chaitanya,
We can achieve dynamic dimension with help of parameter.
But can select and show only one dimension at a time.
Write a parameter with list of dimension names
Then write calculation
CASE [Parameters].[Dimension Names]
WHEN 'Region' THEN [Region]
WHEN 'Segment' THEN [Segment]
WHEN 'Shipmode' THEN [Ship Mode]
END
And drag that calculations in rows shelf.
-
4. Re: Multi- Select Dimensions as Filters in dashboard
Chaitanya Khurana Jan 16, 2019 6:38 AM (in response to megha gawali)Thanks Megha for looking into it.
Parameter allows to select only one value in dropdown list. But the requirement is to select Multi dimensions as we have for the measures.
-
5. Re: Multi- Select Dimensions as Filters in dashboard
Chaitanya Khurana Jan 16, 2019 6:42 AM (in response to Shinichiro Murakami)Hi Shin,
As requested, I have attached the expected view along with the workbook.
Thanks,
Chaitanya
-
6. Re: Multi- Select Dimensions as Filters in dashboard
Shinichiro MurakamiJan 18, 2019 9:29 AM (in response to Chaitanya Khurana)
This does not fully meets your request anyways.
Three parameters for respective layer, and create three respective calc field, and put in the table.
Thanks,
Shin
-
7. Re: Multi- Select Dimensions as Filters in dashboard
Chaitanya Khurana Jan 22, 2019 9:37 PM (in response to Shinichiro Murakami)Thanks Shin for helping me out. Appreciate it.
Regards,
Chaitanya
-
8. Re: Multi- Select Dimensions as Filters in dashboard
Shinichiro MurakamiJan 22, 2019 9:20 PM (in response to Chaitanya Khurana)
Hi Chaitanya,
You are welcome.
Shin