cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
Microsoft
Microsoft

In this blog, I will explain how a redundant ‘Return’ statement in a Power BI Measure can cause huge performance issues.

Read more...

Microsoft
Microsoft

Querying Premium Capacity Health Metrics using XMLA EndPoint

Read more...

Super User I
Super User I

If you ever need to display lower values above higher values in a line chart ("reverse" the y-axis), you will not (to date) find an option out-of-the-box within the default visuals provided by Power BI. The good news is there is a (relativley simple) way of achieving the same effect (at least with a Line Chart visual).

Read more...

Power BI Team
Power BI Team

Join us to thank the Power BI Community for 5 Years of contributions and helping others. Get a sneak peek of the event, and to find out more on our blog.

Read more...

Kudo Kingpin
Kudo Kingpin

One of the amazing things around the challenge is the variety of participants and their backgrounds. Sharing thoughts and ideas from individuals with different background and expertise allows us to improve our vision of what’s possible and how we can sometimes see the same problem in a different light.

 

Picture1.png

 

 

 

Read more...

Super User IV
Super User IV

Excel Functions starting with E

Read more...

Community Champion
Community Champion

Incremental refresh is great in WORM situations. WORM stands for Write Once Read Many.  (There is a variation to that called WORN.)  Examples are industrial sensor data that will be captured once and will never change again.

 

In the business world, a frequent scenario is data that changes ever so slightly after it has been initially written.  A simple example would be a transaction record that gets its transaction value corrected two weeks after it was originally written.  A more extreme example would be the Sales Stage of an opportunity - that attribute goes through a whole lifecycle before settling down as won or lost.

 

This article proposes an approach how to handle the described data sources in a way that incremental refresh can be applied.

Read more...

Microsoft
Microsoft

Automate the dataflow refresh in Power BI, whenever there is an update in an Excel file stored in Teams/SharePoint.

Read more...

Advocate II
Advocate II

In practical business, data iteration is widely used, such as present value or depreciation. However, as we all know, DAX is a functional language based on column engine, each row of data is calculated based on its own row context. But sometimes ...

 

Iteration in DAX.png

Read more...

Microsoft
Microsoft

In this blog, I would like to address one of the issues that I came across recently with the RANKX function where the Ranking Score is different, even though the Sales Amount is exactly same.

Read more...

Microsoft
Microsoft

I have a report with row level security (RLS) implementation; when a user logs in, they have visual filter pre-selected on the last published value, whether they can or can’t access that portion of data.

Read more...

Regular Visitor

Advanced methods for accessing the data underlying Power BI matrixes

Read more...

Kudo Kingpin
Kudo Kingpin

I really enjoyed recently working through the latest Power BI Challenge from Enterprise DNA. This was not an easy scenario that we were dealing with. We had some HR consultation data and the required analysis was quite unique.

 

Picture1.png

 

Read more...

Helpful resources

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