Forum Discussion

StuartSmith's avatar
StuartSmith
Power Participant
5 years ago
Solved

View DAX Code behind Filters.

Is there a way to see the code behind filters i apply via the GUI.  As an example, in MS Exchange, you can view the Powershell script of an action you apply via the Exchange GUI, so the next time, yo...
Need Help
  • blopez11's avatar
    blopez11
    5 years ago

    Yes

    If you enable the "Performance Analyzer" in the desktop

    - go to View tab, then select "Performance analyzer" in the "Show panes" group

     

    Go to the tab that your visual in question resides in

     

    In the "Performance analyzer" pane, select "Start recording", then "Refresh visuals", then "Stop"

     

    You should find your visual under the Name column, then expand the group and select "Copy query"

     

    That query will show you the query used for the visual and you should find how the "Filters on this visual" is used

     

    Good luck,

blopez11's avatar
blopez11
Super User
5 years ago

Yes

If you enable the "Performance Analyzer" in the desktop

- go to View tab, then select "Performance analyzer" in the "Show panes" group

 

Go to the tab that your visual in question resides in

 

In the "Performance analyzer" pane, select "Start recording", then "Refresh visuals", then "Stop"

 

You should find your visual under the Name column, then expand the group and select "Copy query"

 

That query will show you the query used for the visual and you should find how the "Filters on this visual" is used

 

Good luck,

StuartSmith's avatar
StuartSmith
Power Participant
5 years ago

Thanks