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