Forum Discussion
Browsing Cube in PowerBI
are you wanting to expand individual rows?
If you want to expand all the data you can use the new matrix visual, you can also drill down into the data but sadly I dont think you can expand an individual row in the table/matrix because i have been looking for a solution like this too and haven't found one yet.
seems to be a common requirement so i hope the power bi team sort it out soon.
You could use the new matrix visualization for drill down. You could also just add a date slicer perhaps?
Hi powerBI_L1,
You can create a report connect live to SSAS in desktop, which you can get all dimensions and measures like in SSMS. Then there are two methods you can try:
1. Publish that report to a Power BI app workspace. Grant member Edit permission in this app workspace. Each member can edit the report. See: Create and distribute an app in Power BI
2. Publish that report to My Workspace, then create a content pack to package report and dataset, publish the content pack to whole organization or specific group. End user can get this content pack and make a copy of content pack to customize it. See: Intro to organizational content packs in Power BI.
To get expand and collapse feature, you can vote on this idea: Matrix +/- Collapse/ Expand Buttons. You can slicer data in matrix preview on different levels as suggested by other guys: Use the new Matrix visual in Power BI Desktop (Preview).
Best Regards,
Qiuyun Yu
Thanks smoupre for the help. I am using MDX and "Connect Live" connection. I guess thats direct query,so i do not see any explicit connection "DirectQuery" in PowerBI Desktop.
The issue is giving the end user the ability to slice and dice the data. Let me explain with an example. Say, you have TotalSales as Measure and Date as Dimension and Date is a hireachy( Year- Quarter- Month).
So, Rigth now, I am using Table Visualization( I do not want any bars\graphs for this), and it giving stragith Table display. There is no way for me to collapse\expand(slice\dice) the data by based on the Date dimension.
I want the end user to have the ability to slice and dice the date dimension as needed.
Community Championare you wanting to expand individual rows?
If you want to expand all the data you can use the new matrix visual, you can also drill down into the data but sadly I dont think you can expand an individual row in the table/matrix because i have been looking for a solution like this too and haven't found one yet.
seems to be a common requirement so i hope the power bi team sort it out soon.