All values of all levels of a hierarchy available in Report Parameter Selection in Paginated

[Anonymous]

Hi, 

I have a hierarchy like the one below:

Level 1	Level 2	Level 3
A	B	D
A	B	E
A	B	F
A	C	G
A	C	H
A	C	I

I please need all the available values of all levels available for selection as a single Report Parameter in Paginated. As follows:

Parameter

A

B

C

D

E

F

G

H

I

Please help me. I think that it can be done with DAX 🙂

[Anonymous · Accepted solution]

Hi @Anonymous ,

Based on your problems, here are my answers.

I create a table as you mentioned.

Open Power Query, select Unpivoted Columns, save and exit.

Then I create a new table and write the DAX code.

Table 2 =
VALUES ( 'Table'[Value] )

Finally you will see what you want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.