Right now we can create hierarchies in PowerPivot but I'm pretty sure I can't do it in PowerBI. I could create a Data Model in PowerPivot and use that for PowerBI I think. Is there any other work around that could be more desktop based?
Thanks! Mike
4
-
1What would you like to achieve?Rory– Rory2015-06-15 10:26:29 +00:00Commented Jun 15, 2015 at 10:26
-
I want to make a hierarchy in a PowerBI dashboard. After creating this, I can do drill downs and some other hierarchy related tasksuh_big_mike_boi– uh_big_mike_boi2015-06-15 20:16:57 +00:00Commented Jun 15, 2015 at 20:16
-
2Are you talking about PowerBI Preview? Click on Edit Report and drop one field under another in the axis area. That will allow you to drill through from one level to another.Rory– Rory2015-06-15 20:59:49 +00:00Commented Jun 15, 2015 at 20:59
-
Ok that works. I am using the PowerBI Dashboard designer that is desktop based. I am still interested in creating hierarchies overall, similar to doing it in PowerPivot in the diagramming model.uh_big_mike_boi– uh_big_mike_boi2015-06-16 04:46:52 +00:00Commented Jun 16, 2015 at 4:46
Add a comment
|
1 Answer
You cannot create a hierarchy in the Power BI Dashboard Preview or in Power BI. If you want this feature I would encourage you to add it to the proposed feature list here: https://support.powerbi.com/forums/265200-power-bi or vote for the item if it already exists.
You can create hierarchies in Power Pivot and deploy the model to Power BI Preview but the hierarchies are not visible.
