Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Find articles, guides, information and community news

Most Recent
ibarrau
Super User
Super User

The world of DAX is on fire with the release of new functions at the end of 2022. Many posts on various blogs have appeared showing many scenarios explaining the new functions.

Most articles try to explain the functions. This article will overlook that and will try to compare how time intelligence functions respond with traditional code compared to the new DAX functions to solve those classic date scenarios.

Read more...

v-jingzhan-msft
Community Support
Community Support

Scenario: 

Sometimes when we create a report, we may want to implement a complex data sorting in visuals according to multiple ranking rules. This is not easily done by sorting by a single column or ranking by a single expression. We will need some DAX techniques to get there.

In this article, we want to sort car brands in a table visual according to several rules. And when a ranking is selected, a dynamic display includes the two car brands prior to the selected ranking.

Read more...

v-tangjie-msft
Community Support
Community Support

Scenario:

In this article, we'd like to achieve a scenario that distributes a table's data into two visuals for displaying while still filtering them with a single slicer.

 

The detailed requirements are: Create a report with two table visuals and one slicer visual. Two table visuals are created with the same table fields but the data that showed is different, e.g. each table visual could only display half of the data. And when we select items in the slicer, two table visuals will render the data according to the selections.

Read more...

v-xinruzhu-msft
Community Support
Community Support

Scenario:   

There are various types of visuals in Power BI that we can use to create a beautiful report to get business insights from data. However, sometimes a visual may not be able to satisfy some certain requirements. If it is an open-sourced visual, you may have a choice to modify its code to meet your specific requirement. In this article, I will take Gantt 2.2.3 chart as an example.  

customer recently used Gantt 2.2.3 charts in Power BI Desktop and the customer noticed that the maximum number of its tooltips was 3. When trying to put more fields in it, it shows yellow lines and it doesn't seem to allow any more fields to be added to it. Below I will explore how to overcome this limitation for this visual.  

Read more...

v-tangjie-msft
Community Support
Community Support

Scenario: 

In this article, we would like to realize circular dependency columns using M function “List.Accumulate” in Power Query.

Read more...

Dangar332
Resident Rockstar
Resident Rockstar

Unlock the power of precise working day calculations! Learn how to exclude holidays and weekends for accurate insights in your data analysis. Calculate Working days excluding weekends and Holidays. Calculate fore-cast Date without include of weekends and Holidays

Read more...

Arul
Super User
Super User
v-jingzhan-msft
Community Support
Community Support

In some scenarios, we need to use RLS to restrict user’s access to certain data, but this can conflict with certain calculations involving overall data, such as rankings. In this article, I will show you how to achieve this. 

Read more...

v-kongfanf-msft
Community Support
Community Support

How to dynamically select the default values we need in a slicer in Power BI

Read more...

v-xinruzhu-msft
Community Support
Community Support

Scenario: 

In Power Query, when we encounter intricate data structures and the native functions in M script are insufficient, we can resort to other languages for implementation. Given that Web.Page is compatible with HTML, I will utilize JavaScript for the execution of regular expressions, which is a more straightforward approach compared to using M script. 

Read more...

barritown
Super User
Super User

DataViz experts from all around the world propose a lot of techniques and best practices to make your visuals more simple and yet more appealing. Some of those techniques and best practices are just a couple of clicks away when you are eager to apply them in Power BI, but some of them require a little bit more efforts, hence clicks.

 

In this blog entry, I will share with you a decluttering technique for a line chart which belongs to the latter category and allows you to get rid of the legend on your Line Chart visual and replace it with labels assigned to lines.

 

Intrigued? Keep reading then!

 

If you prefer consuming visual materials to reading, don't hesitate to find pretty much the same content in the form of shorts on my YouTube channels.

 

Here they are - in English and in Russian.

Read more...

Arul
Super User
Super User

Create a filter that allows users to select the number of failed attributes.

Read more...

ibarrau
Super User
Super User

There are certain processes that are necessary according to various circumstances. Among them, a classic situation often arises where a report has been published for a long time in a workspace where it should never have been, or simply the organization's structure has changed and it should not be there anymore.

For these and many other reasons, this article will show us an interesting method from the Python library to use the Power BI Rest API that will help us move a .pbix from one workspace to another.

Read more...

Fowmy
Super User
Super User

Streamline Power BI development with Tabular Editor Macros—a time-saving solution for automating Dates Table creation. Enhance efficiency and ensure consistency in your projects effortlessly.

Read more...

SamInogic
Super User
Super User

While creating reports using the On-object feature, we can easily construct and format the visuals. So, working with visuals becomes more convenient and simpler.

 

Read more...

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.