Teo on 06 Mar 2017 20:46:10
Qlik supports conditional dimensions. For example, the user can click a dropdown on top of the first column in a table and select another field. This binds the first column of the table to the selected field. So, instead of having a bunch of tables to show sales by product category, product, customer type, etc., there is just one table that can be dynamically rebound. In Power BI, this can be supported by allowing expression-based fields in the areas when configuring the visualization.
- Comments (2)
RE: Conditional Dimensions
'+1, voting this feature up. This is a high demand function for our internal and external stakeholders and right now just been answering the questions like "maybe this will be a feature in the future from Microsoft". The other tools support this in a relatively easy way but in PowerBI, the only "solution" I've seen is to create an artificial join table in query editor but this is not user friendly and ready-to-use out of the package. This way, the BI analyst has more real estate for other visuals rather than recreating each one to support various cuts. Have one visual with a dropdown slicer that changes the dimension displayed in the visual. Please include as a feature and this will help PowerBI win this fragmented BI war.
RE: Conditional Dimensions
Very useful feature, our users are asking for it. Besides that, it is available in other BI solutions so it should also be implemented into Power BI, to keep up with competition.