I am building one dashboard which has one requirement of building a crosstab graph dynamically means end users can select dimensions and measures dynamically. I know we can pull measure names in the filter and show in a dashboard as quick filter. Is there a way to have multi select filter for the dimension names? If you implemented this kind of scenario, Plz suggest solution.
Message was edited by: Chaitanya Khurana
Jan 11, 2019 12:39 PM
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 ..
Jan 11, 2019 4:27 PM
Hi Chaitanya,
Please attach mocked up sample data as twbx and illustrate your expected view.
Thanks,
Shin
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.
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.
Hi Shin,
As requested, I have attached the expected view along with the workbook.
Thanks,
Chaitanya
Jan 18, 2019 9:29 AM
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
Thanks Shin for helping me out. Appreciate it.
Regards,
Chaitanya
Jan 22, 2019 9:20 PM
Hi Chaitanya,
You are welcome.
Shin
