Power BI

I strongly believe that it is key to describe everything that you have built as part of your Power BI model. As we all have a hate-love relationship with documenting our work, the external tool tha…

Warren DeanData God of the Week 5/13/2021Warren has been a great partner in contributing to the Data Visualization Guide. Make sure you check it out!Justyna LucznikData Goddess of the Week …

Bottom N Analysis in Power BI

Power BI Bookmarks Tips. Bookmarks are powerful and can improve the reader's experience. However, there are several settings to be aware of.

TBD

This article provides a complete explanation of the behavior of the ALLxxx functions in DAX. When used as filters in CALCULATE, ALLxxx functions might displ

DAX is simple, but it is not easy. I cannot remember how many times I read this sentence on social media, attributed to me. For good reason: I have repeated

Typically, when you create a Power BI report, you provide the end user a view to the present and past time. For decision makers this rarely is enough, since decisions should be also based on predic…

In this tutorial, I’d like to discuss how you can improve your creativity when creating custom visual reports in Power BI. I highly recommend creating projects that are outside your organization’s environment. This is because when creating projects for your organization, your creativity is limited. M

A client had a problem with his report. I was asked to find the issue and solve it. This is the story about it

In a previous story, I explained some details about Semi-Additive Measures. Here are some more hints on this topic

In this article we show some techniques to force a measure to return zero instead of blank, in order to highlight combinations of attributes with no data. P

When I am working with the Power BI REST APIs I am regular visitor of the API documentation. I always learn a lot about the data when I am building a Power BI report so I thought it would be a useful exercise to create a Power BI version of the API documentation. If you […]

Have you ever wanted to export a table from Power BI Desktop into Excel just to make sure the DAX you’ve written is performing as expected but ran into this error message: “Data exceeds the limit – Your data is too large. Some data sampling may occur”? Most probably this has occurred because you’ve got […]

User Id or User Group based pages in Power BI report UI Our target is to make one report that has different pages to users depending on which AD groups they belong to. Alternative implementation methods Our requirement is simple and basic, but Power BI doesn’t support this type of solutions, so the ...

ADDCOLUMNS: Returns a table with new columns specified by the DAX expressions. https://dax.guide/addcolumns/

Learn how to push your report level measures into your tabular model!

How the presence of nullable columns affects the way Power BI and Power Query generate SQL

Explore how to create custom groups based on a slicer selection in Power BI. For example, create two versions of a measure: one returns the value of the sel

Do you ever get the feeling that you you’re participating in a completely different conversation than the person you’re talking to? Maybe you are. Back in December[1], Power BI MVP Lars…

Learn how helpful can the add prefix and suffix in Power BI and Power Query can be. You will learn it through an example of generating URLs.

Important updates for workspace admins and Power BI admins, we are extending the timeline for upgrading classic workspaces to new workspaces.

Have you been wondering how to measure the impact of different brands, persons, or organizations on Twitter? Now, you can. DataChant released a new Power BI app on Microsoft AppSource that allows you to search for any Twitter handle, hashtag, brand, or mentioned keywords and analyze their impact over time. The new app is our […]

Calculated tables are not used often, because after all, it only combines data that you already have, right? Well, I didn't use them often, until recently...

Calculation groups can apply specific calculations onto existing DAX measures. For example, calculation groups can implement time intelligence calculations

Dev Consultant Jean Hayes spotlights Data Analysis Expressions (DAX) with Calculation Groups. Power BI Premium (Preview), Azure Analysis Services and SQL Server Analysis Services 2019 now support Calculation Groups! Why am I so excited? Because this functionality was one of the best capabilities in Multidimensional Analysis Services through Named Sets and Calculated Members.

This story is intended to share small bits of code that I have found extremely useful in my day to day activities as a Power BI consultant.

Power BI has the built-in feature of creating binning for a numeric field such as age. However, the default binning will create bins of equal size. If you want to create bins of different sizes, then …