2334

Composite models when connected to AS models (PBI datasets and Azure Analysis Services)

We really love the new feature of 'Composite Models' in the Power BI July 2018 update! This enables us to join custom lists with DirectQuery sources. It would also be beneficial if this would also work when connected to SSAS Tabular in DirectQuery. This would stronlgy improve the enterprise fe...

Read more...

254 Comments

Read more... 254 Comments

STATUS DETAILS
Planned
2020 Release Wave 2
Ideas Administrator
2248

Multiple Y-Axis on a chart

We would like to have multiple y-axis on a chart, more than 2

Read more...

214 Comments

Read more... 214 Comments

STATUS DETAILS
Needs Votes
Ideas Administrator
Multiple y-axis for Cartesian charts is on our backlog. I don't have a timeline to share, but please keep voting. I'll update the idea once we have more information to share.
2071

When showing subtotals at the bottom, show the attributes there as well and not on top

When I choose the option to show the subtotals at the bottom, I expect to see the attribute name there as well and not just on top. This is especially crucial for financial statements, like shown here: https://wp.me/p6lgsG-YC An option to toggle between showing attributes at the bottom only or ...

Read more...

65 Comments

Read more... 65 Comments

STATUS DETAILS
Needs Votes
2068

Clustered+stacked Chart

A column/bar chart with both clustered and stacked features (stacked clustered bar/column chart). http://www.originlab.com/doc/en/Tutorial/images/Clustered-Stacked_Column_Chart/Clustered-Stacked_Column_Chart.png

Read more...

228 Comments

Read more... 228 Comments

STATUS DETAILS
Under Review
1930

Dynamic Date Slicer (improve relative date slicer)

This is a repost of my idea that was closed as completed, but the 'relative date slicer doesn't allow any of the described request hence my idea is not implemented.... The new date slicer is awesome, but it would be so nice if you could set a dynamic date selection instead of a static. With a st...

Read more...

94 Comments

Read more... 94 Comments

STATUS DETAILS
Planned
Ideas Administrator
The relative date slicer (a Preview feature as of June '17) gets us close to this with the 'This Month' or 'This Year' settings. That is a dynamic date selection that updates based on the current system date. We plan to add a 'YTD'/'MTD' option to specifically select a range from the start of the month/year up to today, hopefully that'll address the remaining requirements!
1891

Show column data profile statistics in header

Add a column data profile histogram in the data view for every column in Power BI Desktop. This handy feature exists in Power Query (sometimes only on sampled data). Add this feature to Power BI Desktop as well, please.

Read more...

11 Comments

Read more... 11 Comments

STATUS DETAILS
Under Review
Ideas Administrator
Great idea! Keep the feedback coming - we'll update this item as we make progress.
1745

Security - Ability to maintain source security for reports published on BI Sites

The general requirement is that visualizations (Power View, SSRS etc...) must not circumvent existing policies, or introduce yet another set of security policies on top of those already implemented at the source. * For example, a visualization of sales data needs to reflect the policy that acc...

Read more...

143 Comments

Read more... 143 Comments

STATUS DETAILS
Under Review
Ideas Administrator
Hey all! We've continued to make progress here, so I wanted to update this thread with our current capabilities for maintaining security on dashboards/reports. As always, all of this information can be found in our Row-Level Security (RLS)documentation: https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/ > If you have set up RLS in Analysis Services, Power BI will send the signed-in user's credentials to Analysis Services, and respect the RLS rules set up on the on-premises model. > Separately, you can set up RLS in Power BI for data sources that you import or connect to via DirectQuery. This process starts in PBI Desktop, where you define roles, and write DAX to constrain what data these roles can see. As part of this process, can you use the UserPrincipalName () DAX function to get the current signed in user's UPN (e.g. joe@contoso.com). Then, once you publish to service, you can assign users to these roles. Does the above meet your requirements? Please let us know via comments or e-mail. Those of you who requested that the identity of the signed in Power BI user be pass through to Azure SQL, SQL DB, DWH, etc.: we hear you - that is under consideration. Thanks, -Sirui
1635

Calculated measures when live connected to MDX cubes

In May 2017 Power BI Desktop started supporting creation of DAX measures when working in live connect mode to an external SSAS model: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/ Vote on this idea if you want support for calculated measures against multidimensi...

Read more...

151 Comments

Read more... 151 Comments

STATUS DETAILS
Needs Votes
1611

Drill Mode By Default

It should be good if we can set Drill Mode ON/OFF by DEFAULT instead of clicking manually on the arrow every time on report.

Read more...

283 Comments

Read more... 283 Comments

STATUS DETAILS
Planned
Ideas Administrator
We are working on improving drill in the coming months. Stay tuned.
1589

Clear all slicers

Clear ALL slicers on a page with one click, perhaps an addition to a slicer for a clear all slicers button or perhaps a custom visualization that is a button to press to clear all slicers.

Read more...

59 Comments

Read more... 59 Comments

STATUS DETAILS
Needs Votes
Ideas Administrator

You can do this with a bookmark or "reset to default". Leaving this idea open for more votes.