Forum Discussion

boraJustmop's avatar
boraJustmop
Frequent Visitor
3 years ago

Changing Filtered Field Dynamically in Dax

Hi ,    I'm having a problem that I have been trying to solve for a while. I ve been keep searching for the solution but I m not sure if there is a solution. Let's go through from a simple example...
v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi boraJustmop ,

 

Have you ever considered about field parameter?

Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report. This feature can help your report readers explore and customize the analysis of the report by selecting the different measures or dimensions they're interested in.

Here is my sample:

First create a field parameter:

Then create a new table visual:

Final output:

Best Regards,

Jianbo Li

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