cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Find articles, guides, information and community news

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

monaraya
Microsoft
Microsoft

Querying Premium Capacity Health Metrics using XMLA EndPoint

Read more...

PaulDBrown
Community Champion
Community Champion

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

KellyK
Community Admin
Community Admin

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

EnterpriseDNA
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...

Greg_Deckler
Super User
Super User

Excel Functions starting with E

Read more...

lbendlin
Super User
Super User

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

monaraya
Microsoft
Microsoft

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

Read more...

DavisBI
Solution Specialist
Solution Specialist

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

monaraya
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...

monaraya
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...

aandi
Frequent Visitor

Advanced methods for accessing the data underlying Power BI matrixes

Read more...

EnterpriseDNA
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.