Power BI Update - August 2024

[@sergiizelenko4114]

Great to see more demo in monthly updates! Thank you :)

[@MicrosoftPowerBI]

💛 🙏

[@martinaroque3047]

Greats updates! But I have a question: In the video, mint 6:12, I don't have the option "Data Format". What can I do to appear? Thank you!

[@lazydeveloper6878]

When PDF export for table or matrix visuals will come ??? I am waiting for more than 2 years every company need this

[@krniketan]

Use Paginated Report Builder

[@danieljoubert7937]

So true man, sucks having to do it through external tools or manually

[@danieljoubert7937]

@@krniketan This can work but our managers do not want the end users to have to do any manual effort to run an extract. They purely want a csv dump via email every Monday. Plus I hate that tool so much. Its like being married to the most miserable Wife constantly giving you trouble.

[@PaulEBrownbill]

Excellent, including the visualisations section. Will check them out. Paul

[@dc-sg8ot]

Visual format is nice! When will we see stage 2 of the slicer visual enhancements?

[@dutchdatadude]

great to hear you're exited for the visual level formatting! Stay tuned for more updates in this area soon.

[@Baldur1005]

Wow, comment section is enabled

[@MicrosoftPowerBI]

Absolutely, we love hearing from our users! What was your favorite feature this month? Anything coming up on the road map that you hope to see as well?

[@blatcher2]

@@MicrosoftPowerBIPlease add fx option for the color on stacked bar charts. I have a measure that controls the colors of each products but have to manually click each bar and select color.

[@MicrosoftPowerBI]

We appreciate the feedback, and encourage you to submit your idea in our idea forum, here: msft.it/6053mGMcU

[@mathieu4323]

Great updates

[@JonathanCHANAL]

When you add a new button in the format pane, it should be great to add the fx button. We need more fx buttons! I don't really like the ability to change measures in the Power BI service because you then have 2 different versions of the same pbix Anyway, this is a great update as always!

[@miguelmyers6093]

Hello, I agree with you, and that's our goal too. The plan is to first understand how to manage conditional formatting in the format pane. If the goal is to support conditional formatting for all our controls, we certainly don't want to overcrowd the pane with a ton of fx buttons. Then, we need to redesign the conditional formatting dialog to support more functionalities such as defining font family, font size, pixels, hide/unhide, and more. We have created a roadmap for this work, and our vision is to invest in it once it reaches prioritization, as there are other features that the team is focusing on right now. I will keep the community informed about this and more.

[@JonathanCHANAL]

@@miguelmyers6093 Hi Miguel, thanks for informations 👍

[@xanthopsized]

Long awaited for visual level formatting ❤ Does it work with SSAS tabular models?

[@dutchdatadude]

great question! Yes, this works with SSAS Tabular models as well.

[@D_Hoffmann_greenique]

I have questions regarding the dynamic per recipient subscription. 1. Is this a feature that a tenent admin needs to activate to try it out? I tried it and I don't get the option to create a dynamic subscription. 2. By "Generally Available" I was under the impression, that this would work under a pro licence without premium capacity. The documentation states the following prerequisite: - Paginated Report: "A paginated report with parameters to share that is saved in a workspace backed by a capacity (Power BI Premium capacity, Microsoft Fabric trial, or Microsoft Fabric capacity)." - Report: "A report to share that is saved in a workspace backed by a capacity (Power BI Premium capacity, Microsoft Fabric trial, or Microsoft Fabric capacity)." If this is the current state I would favor to have a indication in the future about the required licence of a feature. All in all great updates. Cheers

[@MicrosoftPowerBI]

Hi there, thanks for your patience on this, there could be several reasons why you don't see this option for example the report is not backed by a premium capacity or the admin disallowing the capability. Regarding generally availability, this does not mean we will roll out capabilities to other licenses. We appreciate the feedback to mention no license changes, to make it clear going forward. Thanks for reaching out.

[@chad_the_stud]

My Power BI wishlist : Basic Data profiling visuals --- Histogram, R squared and p value on scatter, box plot Advance data science visuals by default visuals, violin plot etc Ability to freeze some visuals like slicers so they stay top of the screen for long vertical reports. Version Control for DAX measures Use cloud computing instead of abusing users' tiny little laptops Please focus on what matters the most

[@MicrosoftPowerBI]

Hey there, thanks for the feedback. As we are always looking for ways to improve, we would encourage you to add your suggestions, here: msft.it/6057lLIsL

[@hagbjork]

Great video and update this month! I like you emphasis first thing that you listen to the community and make adjustment to the format and content of videos. Nice to see more demos 👍

[@MicrosoftPowerBI]

💛 🙏

[@jonvirgi7215]

Is there a feature request for a native toggle button for binary attributes instead of a slicer?

[@MicrosoftPowerBI]

Take a look on the Ideas page to see if the feature has been suggested already, here: msft.it/6050lIPSi

[@mmuse8173]

How can I adjust the ppt template attached to a dynamic subscription email in regards to e.g. changing cover slide and adding additional slides e.g. blank slides for comments on the data.

[@NirupamaSrinivasan-s5d]

Thanks for you comment. That will have to be part of the report definition. The dynamic subscription email is not for dynamic formatting per recipient but more for custom/ personalized content for users.

[@mmuse8173]

@@NirupamaSrinivasan-s5d thanks for the feedback! But is it possible to adjust on a general basis like add a blank slide or customise the first page with corporate identity layout instead of that black slide. Not asking for customize per user/recipients but generally. The template must be sitting somewhere, right?

[@Aussified]

Great update and thanks for making it more digestible.

[@MicrosoftPowerBI]

🙏 💛

[@dexterx9862]

In the visual formatting, can you use a measure in the Data format section to define the format string?

[@dutchdatadude]

No, you can't, dynamic formatting is available only on the model level.

[@cooldeepak6578]

Hi Team, thanks for the update.. do you have any plan to make the message section dynamic where we can pass values from variables under dynamic email subscription feature.

[@tanya-e9j9i]

Love it! Thank you for making our life easier!

[@LucasAugustoMilanes]

+1 month with "big" updates! Let's wait one more month to check again what we will have

[@johnskilly]

When they celebrate the roll out of things that should have been done years ago. What about useful roll outs like being able to click on a measure and see where it´s being used? Or the ability to lock a query when sharing the semantic model with others? Such a frustrating tool.

[@joecronk6158]

I'd love to see a "where used" option on measures in a model, including the ability to see the lineage across all reports using that use the model as its source.

[@PointShotDR]

@@joecronk6158 Yes!!! This is another thing that leaves me baffled. It’s something that should be in the 0.1 Alpha version of Power BI. Until then, we have to rely on tools like Measure Killer.

[@abhijithdsouza8091]

they will never do this, you know why ? There is no money to be made on users who are already locked into the power bi platform as MS knows the users are not going away anywhere. Their entire focus is on getting new users who simply want to build reports and as long as they keep releasing those "wow" formatting pane updates, they will not only get new users but also satisfy the formatting pane fanboys/girls :)

[@AlanLeonardoPiovesan-b3u]

Thanks guys! Great to see more customs.

[@Niclas-v1i]

It would be a great feature being able to put Filter States onto a slicer panel.without having to go the extra mile via creating a parameter

[@joecronk6158]

I wish the Subscription features gave the option to embed the visuals as Live Data in the PowerPoint attachment. It would be great to see a "Subscribe to Visual" option. And it would be awesome to have the option to attach the results as an Excel and/or CSV file as well, as part of the subscription. But one of my biggest issues, preventing us from leveraging subscriptions today, is the fact that only the visible pages in a report can be exported. Unfortunately, we have gone the route of hiding all but one page in each of our reports, and using the page navigator feature for managing the page navigation within a report. This helps keep the navigation a bit cleaner/condensed in our App, which has many reports with many pages. This means that we only have the option to export a single page from each report, making subscriptions virtually useless :(

[@MicrosoftPowerBI]

Hello, thanks for the feedback. As we are always looking for ways to improve, we would encourage you to add your suggestions, here: msft.it/6057lLIsL

[@vpwl]

Great updates! Thank you, as always, for the quick demos!

[@diegoalejandropenalozamayo5997]

When did they release PowerBi's native boxplot visualization?

[@ryankluck5041]

Been dabbling with Power Bi for a little over a year now. I’m a fan, and so is my boss! One request I have: can we get a feature to adjust the background of a visual in focus mode? I’ve been trending towards darker or bold colors for my report backgrounds and then using white or light colored fonts on the visual. When a user selects to view a visual in focus mode, the same formatting for the visual carries over onto a white background. This means white text or very light colored text is difficult or impossible to read. I could see where having the ability to have a custom background for focus mode may be costly in terms of report rendering efficiency, but I feel like just having the ability to change the background to one solid color could go a long way. I think the focus view is a great feature, but it’s unfortunately useless, unless I design my entire report to facilitate a white background, a limiting option in my opinion.

[@MicrosoftPowerBI]

Hey Ryan, thanks for the feedback. As we are always looking for ways to improve, we would encourage you to add your suggestions, here: msft.it/6057lLIsL

[@TrackPace]

I've been watching these updates for 7 years. I hope that one of them will eventually tell me dark mode for desktop is here 😂

[@MicrosoftPowerBI]

Might be coming sooner than you think 😉

[@davidbarrett8569]

While this seems like a step in the right direction for "dynamic per recipient subscriptions", it is still missing a killer feature. Dynamic filtering on Email Recipient is also a necessity. That way, only one subscription is needed for a list of customers. For instance, if I must send all my customers a weekly report of THEIR data, I would need to dynamically filter both the data and recipient list. That way, everyone only gets data that relevant to them. With the current design, I believe I would need to create an individual subscription for each customer which is impractical for most organisations.

[@fitonitube]

I love Power BI as it gets better every day. Is there any roadmap to create some kind of Semantic Layer as found in MicroStrategy?

[@MicrosoftPowerBI]

Hello, you can check out the roadmap here: learn.microsoft.com/en-us/fabric/release-plan/

[@carloscorredor5409]

Good morning Jason, is there a user manual from scratch?

[@anushav3342]

Regarding Recipient Subscription: Do all the recipients need to have the Power BI pro licenses? Since we do not have premium and we are using external service portal for sharing published reports. I am not sure if I could make use of this option and send pdf or ppt to the users. As a Power BI developer I do have admin access to the Fabric workspace and semantic model as well.

[@ankonbiswas-m8c]

When are we getting a Page Level Security?

[@MicrosoftPowerBI]

Keep an eye on the roadmap for what's to come soon, learn.microsoft.com/en-us/fabric/release-plan/

[@ArtfulData]

Amazing! These updates are definitely helping us take our data analysis to the next level. I especially love the DAX queries for web applications-so practical!

[@MicrosoftPowerBI]

Thank you! 🙏

[@PointShotDR]

I’m alarmed by the number of things still missing in Power BI. And it’s even more alarming when I search to see if it’s possible to do extremely basic things and find answers like ‘Why would you want that?’ I can’t accept not being able to condition the color of chart lines, use font sizes smaller than 8, choose the exact font size I want, deal with charts randomly shifting or changing size by 1 or 2 pixels for no apparent reason, STILL NOT HAVING A DARK MODE!, and many other things that should be extremely simple but require 10 steps. Understand that this is criticism from someone who likes the software but is frustrated by how slow the evolution of such an important tool is.

[@ChayanikaArora]

Thank you for this update, Can you please help me with Quick training Modules for Power BI certifications

[@MicrosoftPowerBI]

Hi there! Of course, you can find trainings, here: msft.it/6053m6xOD

[@missingsprocket]

Thank you pbi team for your hard work. I want ask, how is progress coming on conditional formatting for visual level calculations? I've got some visuals that crunch through deep datasets of hundreds of thousands of records and having to use a measure that recalculates the summarized data just to show a difference in values and once again change the background color of a cell is a real performance killer. I'm doing 3x the calculations as is needed compared to if visual calculations supported conditional formatting.

[@melodym5993]

Great video, thank you! Question: can we prevent users from editing our dax in the workspace? This can be dangerous if they don't understand the relationships between the tables, or how the data from the model works in conjunction with the paginated reports or downstream flows.

[@datazoepowerbi]

Great question! Yes, currently DAX query view in web is only for model authors, so you have to have write permission (meaning you can edit any of the DAX, relationships, remove or add tables, etc even without using DAX query view in web) to use it. You can also turn off the ability to edit models in the workspace in the workspace settings/Power BI if you prefer not to allow this functionality. Even without this functionality, write permission users can always make changes to the semantic model using other methods. In a future release, we will have DAX query view in web for just Read/Build users, and that will not allow any edits to the semantic model itself, so users will be limited to just writing DAX queries without any access to edit the model. And for right now to allow users to write DAX queries without access to the write to the model, they can live connect to any published semantic model in Power BI Desktop and use DAX query view there.

[@melodym5993]

Thanks so much, appreciate it!!

[@analytikmindz5390]

Amazing..!!!

[@MicrosoftPowerBI]

🙌 🙌 🙌

[@1yyymmmddd]

Beware, few months (tested on March, 2024 reports) old reports do not open in this new version.

[@AzizagaAzizaga]

I would like to control scrollbar in any visual in Power BI. Especially in Matrix visual. Like custom control any colour, width, height, type of scroll bars, text on scrollbar, although going to end, upping to top buttons for visual

[@MicrosoftPowerBI]

Thanks for your feedback! We suggest letting the team know via the Ideas page, here: msft.it/6051lAB1D

[@EverythingPants]

Please, Please, Please change the selection principle to be "every object your selection box touches" (as per PowerPoint) and not the current "Everything that's fully inside your selection box"! If you have objects that touch each other, or touch the side of the screen it's very hard to select those objects along with others. Also, the CTRL key in Windows applications is used to manually select multiple objects, but you've used that for navigation in the designer. So I can't manually select two objects using CTRL if one is a button or link, as it takes me there instead!

[@roshanmohapatra8874]

I want to build my career as a power bi developer do not want to work in Customer support anymore. However, is 28 years too late .? I have learnt this Data Visualization tool and I loved this and Tableau a lot.Its really interactive.

[@MicrosoftPowerBI]

Hey there! It's never too late, in our opinion ✨ You can find trainings for Power BI, here: msft.it/6051lLItF

[@learntech5183]

DAX queries on web is awesome...no need of ALM toolkit now,right...

[@MicrosoftPowerBI]

💛

[@ChrisStewart-mn5wm]

Tron says: and/or logic in filters pane please. And option to paste in lists of filter values.

[@miguelmyers6093]

The Core Visuals Team has those two items listed in our roadmap, we'll inform the community as soon as they reach our development backlog.

[@NukeIncharge]

Thank you for regular updates but visual level formatting is unnecessary since dynamic formatting exists, visual level formatting becomes irrelevant when we need to show multiple units of measurement. Kindly pay visit to your visuals gallery as well and improve the existing Microsoft charts.

[@dutchdatadude]

hey @NukeIncharge - thanks for the feedback. You can't apply dynamic formatting to visual calculations and you need to understand format codes (and a little bit of DAX) to be able to use dynamic formatting. We will expand the visual level formatting options soon.

[@1yyymmmddd]

... and where are the Dynamic per recipient subscriptions?

[@1yyymmmddd]

Is this feature available in $5000+ plans only ?

[@NirupamaSrinivasan-s5d]

@@1yyymmmddd : This is a premium only feature at this time.

[@MicrosoftPowerBI]

Hi there, Dynamic per recipient subscriptions are supported for Power BI Reports and paginated reports that are in workspaces backed by premium capacities. You can read more in the documentation.

[@1yyymmmddd]

@@MicrosoftPowerBI PPU inclusive ?

[@sergiodavidmartinezrojas525]

hello power bi developers, I would like for the next updates to take into account these ideas: as a first idea the possibility of blocking the display of queries or databases, and that you can only access the report view or presentations, but not the databases that feed those reports, that a password is requested for it. And as a second idea a presentation mode for power bi desktop for reports, as in power point when you give F5 or activate the presentation mode, in order to facilitate navigation in the dashboard or reports. Thank you to take into account these ideas

[@MicrosoftPowerBI]

Hey there, thanks for the feedback. As we are always looking for ways to improve, we would encourage you to add your suggestions, here: msft.it/6057lLIsL

[@renangoncalves185]

Please, in the next update, create a search field within the currencies option to search for a specific currency, I'm Brazilian and I always need to scroll down to search for the Real currency, this would save a lot of time! Thanks

[@renangoncalves185]

However, congratulations to new update!! 🤩

[@MicrosoftPowerBI]

We appreciate it! 😄💛

[@MicrosoftPowerBI]

Hi there, thanks for the feedback. We would encourage you to add your suggestion here: msft.it/6058lLG5k

[@Factfactorization]

How to learn power bi ?

[@MicrosoftPowerBI]

Hi there! You can find Power BI trainings, here: msft.it/6052m6xMw

[@systematical88]

Still dont even have dark mode on desktop.... Beyond disappointing.

[@MicrosoftPowerBI]

It's on the roadmap for this quarter, learn.microsoft.com/en-us/fabric/release-plan/

[@arunmurugan252]

❤

[@AdamCampbell925]

Dark mode?

[@MicrosoftPowerBI]

Hi Adam, it's still on the roadmap aka.ms/pbiroadmap.

[@martinbubenheimer6289]

When will we get a predictable, straight forward way to include a measure result in text boxes? With the current dynamic values it's so random PITA what values Power BI proposes. You cannot simply type a measure name and it will be included in the proposals. It's not even teachable.

[@juanfelipe6341]

-------------------------> Button of Dark mode in Power BI Desktop Please

[@MicrosoftPowerBI]

It's on the roadmap for this quarter, learn.microsoft.com/en-us/fabric/release-plan/

[@technicalanveshana]

I'm the first person to view the update video !!