Skip to main content

    Power BI

    Needs Votes

    DAX Query Language Visual

    Vote (1460) Share
    Matt Allington's profile image

    Matt Allington on 04 Nov 2017 04:26:24

    I see big value in creating a visual that can display the results of a DAX query. One way this could be deployed is a follows.
    * Add the new visual to the report canvas
    * Write a DAX query that returns a table (of course) and add this to the visual
    * The visual would respect any cross filtering coming from the report just like any other visual.

    This would give report writers very granular control to display records without having to use a table visual and a measure that triggers the display of the correct records.

    Administrator on 30 Jul 2020 16:56:46

    At the moment we don't have any plans to implement this. It sounds like it's mostly useful for learning/training? If there are other 'production' scenarios that you think it'd be useful, where a regular table/matrix wouldn't work, please let us know in the comments!

    Comments (23)
    Matt Allington's profile image Profile Picture

    133f1aaf 17aa-40bf-96b7-7cf2e415e4aa on 05 Jul 2020 23:03:34

    RE: DAX Query Language Visual

    Great suggestion. I find this capability very useful in Excel.

    Matt Allington's profile image Profile Picture

    355a81e2 0dac-47d2-a1b9-e63ff15e5227 on 05 Jul 2020 23:03:34

    RE: DAX Query Language Visual

    I also do this in Excel, but in Excel it doesn’t respect filters. If it would do this is would be killer!

    Matt Allington's profile image Profile Picture

    b79041ae 3f13-4d8c-b0a5-ddc2fd5c8bec on 05 Jul 2020 23:03:34

    RE: DAX Query Language Visual

    A visual that you can use with a "drop" of a table instead of a drop of a column or measure and then responds well to cross-filtering has my vote!