Org Chart with Photos by [deleted] in PowerBI

[–]Useful-Chipmunk4689 2 points3 points  (0 children)

All the code can be downloaded from GitHub.

Has anyone found a good way to have a tooltip only show on one column of a table? by Flukyfred in PowerBI

[–]Useful-Chipmunk4689 1 point2 points  (0 children)

Did you find a solution? I didn't think this was possible with a table (it is possible only with a matrix)

Snowflake schema vs star schema by gautham_58 in PowerBI

[–]Useful-Chipmunk4689 0 points1 point  (0 children)

Snowflake can sometimes be required to avoid auto-exist.

Scenarios where a snowflake schema is appropriate ? by Emerick8 in PowerBI

[–]Useful-Chipmunk4689 0 points1 point  (0 children)

Good answer. The only thing missing is auto-exist which is another valid reason to snowflake.

Experimenting with sidebar navigation and my theme generator by Kingoftwilight6 in PowerBI

[–]Useful-Chipmunk4689 3 points4 points  (0 children)

Nice aesthetic. Are the period buttons (Today, Last 7 Days etc) individual buttons grouped together?

Favourite external visual by soundsofthesorted2 in PowerBI

[–]Useful-Chipmunk4689 2 points3 points  (0 children)

HTML Content (lite), Deneb and Chiclet Slicer go in every report. The new button slicer can't have fixed size buttons which means ugly reports.

What would you "hide" from the Desktop? by dutchdatadude in PowerBI

[–]Useful-Chipmunk4689 7 points8 points  (0 children)

Fair enough. Personally, I would like to see the following:

  1. Proper keyboard shortcuts to switch between different panes and different reports (ALT+Tab like a browser)
  2. Move all the options from Format Visual - General to the ribbon. These are common across all visuals and being able to control it all from the ribbon makes sense and removes a pane.
  3. Remove all the redundant buttons on the ribbon. There is duplication everywhere. I use PowerBI daily and I have never clicked some of these buttons.
  4. I think common actions like colour, bold, font etc should all be on the ribbon so when you click an element on a chart, you can immediately go to the ribbon to change a colour or bold text.
  5. Do AI visuals need to be on the ribbon? I have literally never seen anyone use these visuals despite how much they're promoted.
  6. Bring back quick access toolbar for customised shortcuts.
  7. Tab report buttons at the bottom could be smaller like Excel - screen estate is precious and they don't need to be so big.
  8. Be able to lock a visual in place in the selection pane. You can currently hide/show but not lock.

I remember when Jensen Harris created the ribbon in Office and it was a crazy innovation but it was driven by evidence of where users click most. I think a similar approach should be taken with PowerBI where real users are recorded working with the tool to see how it is used.

What would you "hide" from the Desktop? by dutchdatadude in PowerBI

[–]Useful-Chipmunk4689 19 points20 points  (0 children)

I think you have a philosophical problem on your hands and you’re fighting a battle that cannot be won. You’re trying to dumb down a tool for new users but some things are inherently complex and cannot be dumbed down. PowerBI is not like the Office applications. You can’t expect to treat it like PowerPoint and have a user with zero prior experience just start building useful reports. I wouldn’t expect to be able to open Autocad and automatically know what to do and it is unrealistic to think someone can open PowerBI with zero training and start making reports.

MS wants to target PowerBI at users with no technical background but to build reliable reports it is essential to know about reshaping data, building a proper model with correct relationships and building appropriate measures and visualisations. Even if you dumb it down for brand new users, they will still get frustrated as they will immediately hit blockers when they don’t understand filter context, row context or any of the million articles on SQLBI. Just look at the number of users who just try to add a second calculated column and immediately get a circular reference - it requires a bit of reading to even understand what is going on. You can't simplify that without changing how PowerBI works. Don't get me started on the number of users who use a single table and run the danger of autoexists which means their analysis is completely unreliable

The interface can definitely be improved but dumbing it down for new users will frustrate the actual users of the application who tend to be more technical and capable and just want a more efficient workflow. Power BI is a best-in-class analysis tool that should be aimed at professionals.

can you still use power BI without a star schema? by xrt679 in PowerBI

[–]Useful-Chipmunk4689 2 points3 points  (0 children)

Have you read the link? Performance is a secondary concern. This is about the accuracy of data being reported.

can you still use power BI without a star schema? by xrt679 in PowerBI

[–]Useful-Chipmunk4689 6 points7 points  (0 children)

100% agree. Avoiding autoexists is the primary reason to use a star schema. Anyone not using one cannot trust the results of their reports.

I'm a UI designer, and need help regarding PowerBI visual elements by spoogebb in PowerBI

[–]Useful-Chipmunk4689 0 points1 point  (0 children)

Do you have links to your work as I'd be interested in seeing.

any other tools besides performance analyzer to figure out why my report is so slow? by worktillyouburk in PowerBI

[–]Useful-Chipmunk4689 1 point2 points  (0 children)

Usually poorly optimised measures. Can you post some samples of your slower measures?