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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Find articles, guides, information and community news

Most Recent
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...

SamInogic
Super User
Super User

The utilization of Calculation Groups in Power BI offers significant advantages for organizing and managing complex calculations within reports. By leveraging Semantic Models, we can efficiently structure and consolidate measures, such as Date KPIs and more, ensuring that updates and modifications seamlessly propagate throughout our Power BI Reports. This empowers users to create more dynamic and responsive reports, enhancing the overall data analysis experience. Calculation Groups provide a valuable tool for enhancing the clarity and flexibility of Power BI reports and are a key asset for data professionals and analysts.

Read more...

Dennis_C20
Advocate I
Advocate I

Ever found yourself stuck in a data jam? Managing your data with Power BI might be tricky, but I've got some game-changing tips and strategies that'll help you navigate these challenges with confidence. Let's dive into a common hurdle many teams face – the notorious lack of version control in Power BI. Working on a data project with your team can get messy without version control, leading to confusion and a lack of a standard version of the truth. 

Read more...

technolog
Super User
Super User

Delve into the nuances of data analysis with our latest articles. Discover practical insights on using functions like ALL, ALLNOBLANKROW, DISTINCT, and VALUES in your data sets. Learn how to create effective summaries, understand the intricacies of table-based data models, and enhance your dashboard displays. Perfect for professionals seeking straightforward, efficient data management strategies.

Read more...

mh2587
Solution Sage
Solution Sage

Dynamic titles in Power BI offer several advantages

Real-time Context
User-Friendly Experience
Personalized Analysis
Dashboard Coherence
Narrative Guidance
In summary, dynamic titles in Power BI enhance user experience, providing real-time context, personalization, and improved interpretability of data.

Read more...

AlexisOlson
Super User
Super User

Sharing queries in these forums can be a pain. One simple and common way to do it is as I answered in this post:
How to create json table for easier sharing pbix file

 

There are some drawbacks to this method though, so I've created a Power Query function that takes the output of an existing query  (or table) and rewrites it as self-contained M code that's human readable.

Read more...

Kumail
Post Prodigy
Post Prodigy

Greetings Power BI enthusiasts!

 

Are you ready to revolutionize the way you interact with your data? Say hello to Natural Language Query (NLQ) – your new best friend in the world of Power BI. In this blog post, we'll explore how NLQ can transform your data analysis experience and empower you to derive meaningful insights effortlessly.

Read more...

Fowmy
Super User
Super User

Facing challenges comparing revenue for outlets opened at different times in Power BI? Aligning those launch dates to a single point or day zero can be a common hurdle.

Read more...

Dennis_C20
Advocate I
Advocate I

Power BI is a robust tool that offers an array of reporting possibilities. It helps enterprises streamline their data modeling and visualizations. However, the sheer complexity of the tool can be quite overwhelming, and the platform is only as good as its users.  

Read more...

technolog
Super User
Super User

The article delves into the functionality of the CALCULATE filter in DAX, focusing on how it can be utilized to override existing filters for precise data computation in a sales table scenario. It guides through a process of calculating Profit and Profit percentages, facing issues when external filters are applied. It explores solutions by employing DAX functions like ALL, ALLEXCEPT, and ALLSELECTED to manipulate filter context, ensuring accurate calculations while accommodating external filters.

Screenshot 2023-11-03 at 11.21.32.png

Read more...

barritown
Super User
Super User

Does it happen to you that you are not quite content how Power BI manages things for you on a dashboard and you want to correct them but cannot find the right settings because they just haven’t been invented yet?

Read more...

ibarrau
Super User
Super User

Getting data from APIs and websites is becoming more frequent every day since more and more sites and applications provide the possibility to connect within the platforms.

It's true that reading and interpreting them is not always everything. Good development in programming languages typically uses Try Catch to capture and interpret errors that may arise from requests we make to a web source.

This article will show us how to capture these errors in order to act in different ways.

Read more...

technolog
Super User
Super User

Dive into the intricacies of calculating cumulative totals with precision, exploring the boundaries set by date functions in your data analysis tools. From understanding the DATES series for generating date columns to leveraging the TOTAL series for simplified coding, we unravel the steps to accurate, efficient calculations and visualizations. Enhance your approach by fixing common glitches and optimizing code for cumulative sales computations within specific periods.

Screenshot 2023-10-20 at 11.16.11.png

Read more...

SamInogic
Super User
Super User

Copilot helps you build faster and easier dashboard reports and insights. With Copilot measure suggestions, you can create interactive dashboards and analysis reports.

Read more...

Helpful resources

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