Power BI

Needs Votes

DAX Query Language Visual

Vote (1756)

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 (26)

Comments (26)

Paul Turley on 05 Jul 2020 23:07:32

RE: DAX Query Language Visual

I get the idea but how is this different from adding another table to the model, with or without relationships to other tables?

Andrés Argüello on 05 Jul 2020 23:05:51

RE: DAX Query Language Visual

It would be even better if we could use those dynamic queries in any visual. Like dynamic data layer with tables affected by current context filters. This way we could have dynamically calculated columns and a simpler way to calculate some complex measures.