Need to implement the dynamic measure dimension in report based on user selection it should display.

[Anonymous]

Hi Team,

I am new in power BI. So I need your help to do the requirement. The requirement is that I have a dimension and measure based on user selection the dimension and measure should be populate in the table. I would like to request you please help me to do this.

Regards,

Irshad Ahmad

[v-juanli-msft]

Hi @Anonymous 

Could you show some data example for better analysis?

There is a guide blog How to Get Your Question Answered Quickly in this forum.

It will be much appreciated if you follow the suggestions in this blog to illustrate problem here.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Maggie,

Please find the sample screenshots same like we need result for this report.

Sample screenshots

Somewhat it is working Measure but diamensin i don't have any logic to do.Please hepl me to do.

Regards,

Irshad Ahmad

[Anonymous]

Hi Maggie,

Still, i did not get the solution for this. i would like to request please suggest me to do for dynamic dimention with slicer . Almost it is working for measure but not working for dimension.

Provided the below sample screenshot for your reference. Same like measure the dimension column also display on top of the table based on user selection.

Note: I can not able to attached the excel file as well as power bi file here.

Regards,

Irshad Ahmad

[v-juanli-msft]

Hi @Anonymous 

It doesn't support to use a measure in a slicer or use mutiple columns as filter items in a slicer.

Here is a workaround to select mutiple measures from a slicer.

https://www.burningsuit.co.uk/blog/2018/03/dax-how-to-use-a-slicer-to-select-different-measures/

if you want to change the columns in the matrix with the slicer, it doesn't support to remove old columns and re-add new columns in matrxi automatically.

Here is a workaround to use dynamic dimensions, it may give you some ideas.

https://www.leanx.eu/tutorials/dynamic-dimensions-in-power-bi

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Maggie,

Thanks for your support. Will go through the URL and get back to you in case of any doubt in this.

Regards,

Irshad Ahmad