Setting a Default Slicer Selection
I see a lot of Power BI users asking for the ability to set a default slicer selection in their reports
Category: Page Type
Cube Functions, the good the bad and how to make them great
I’ve written in the past about using the CUBE functions in Excel. The general pattern of the examples I’ve used was pretty consistent:
2 Tips for Visualizations in Power BI Dashboard
Here are 2 tips for visualizations in Power BI Dashboard. In Power BI service (PBIS) there are reports
A different use for Power BI: Self-service refreshes and extracts to Excel while managing security in Power BI
Have you ever needed to get data out to an internal customer quickly to meet an urgent business need, in an easy to access, updateable format?
Reducing DSO using Power Pivot
One of the many things which amazes me about Power Pivot time after time is its ability to effortlessly convert raw data into crucial information as soon as it happens.
Dynamically Embedding Web Pages in Power BI
It’s sometimes difficult to find things that Power BI can’t do. There always seems to be a solution no matter the task at hand. A little while ago I was wondering to myself if it was possible to embed a website inside of a Power BI report.
Automated Testing With Power Query
I loved Nar’s post on Automated Testing using DAX. I especially like the rule of always including controls so that business readers can share responsibility for data quality.
Comparing Rows in Power Query Part 2
We are back to finish our discussion on the visualizations for Comparing Rows in Power Query! How to visualize the prices and daily changes The two metals have very different […]
Finding the Right Data using SQL or Power BI
Well, it’s been a while since I’ve blogged – what can I say, it was a busy summer! BOO you say?! You need your Cat Meme fix!?! Well, let’s see if I can DO something about that!
Comparing Rows in Power Query Part 1
It is straightforward to compare values between each row in an Excel table and the next row.
Power Pivot Cracks Direct Method Cash Flow Conundrum
Many accountants consider that cash flow statements are the most important indicator of a company’s performance, as they do not involve estimates or judgments of the preparers.
Using Dax To Handle Multiple Parent Hierarchies
A common accounting task is to consolidate the financial results of subsidiary companies into combined results of a parent company. A parent company can have one or multiple subsidiaries.