Every time I use a date table in a new Power BI model (so… every time), I have to specify sort order for text columns – e.g. to sort January and February text fields by their month start instead of alphabetically. This is something AI can do for us in bulk with TMDL! All we… Continue reading: Sort and format your date table with TMDL and AI!
With the advent of TMDL, we’re able to use AI to update our DAX measures to add descriptions and inline comments to our code (this links to the video walkthrough)! Here are the prompts we used to do this as well as test results with different LLM models. Prompt 1 – Add Descriptions to Measures… Continue reading: Using AI to Add Measure Descriptions & //Comments to DAX
If you’ve been following the series on how to get Planner data in Power BI, you might also want to create clickable hyperlinks to tasks in your table visuals. Assuming your data structure is the same as that in the linked video, all you need to do is add a custom column in Power Query,… Continue reading: Creating a clickable link to a Planner task in Power BI
This post is an accompaniment to the video tutorial series on creating a project management dashboard on YouTube. In this video, we create measures to measure in-progress, overdue, recently completed, and starting soon tasks, then use those measures to conditionally highlight tasks in a table. We also have a cumulative sum of estimated vs actual… Continue reading: Project Management Dashboard
If you’ve tried out the “visualize this list” functionality in Microsoft / SharePoint lists, you may have noticed that they’re not stored in the typical Power BI workspaces. You’re not prompted to choose a workspace to put the report in, and are instead dropped to a URL in Power BI that starts with “https://app.powerbi.com/sharepointlist/groups/”. If… Continue reading: Where are “Visualize this List” models and reports stored in Power BI?
What’s new and interesting in the world of Power Platform? Power BI From the Power BI Core Visuals vision board: Sidenote, the vision board linked above is also a Power BI report itself – @Power BI Park has a “reverse-engineer” tutorial here. In other Power BI / Fabric news, org apps were also released recently, allowing multiple… Continue reading: December 2024 Power Platform News
Date tables are one of my favorite things in Power BI, right up there with field parameters. Particularly the ability to make all of my date filtering relative is one of the things I really love about them – it can really reduce the maintenance for reports to have measures and filters “stick” to current… Continue reading: Date Tables in Power BI
YES you can use incremental refresh on SharePoint files in Power BI! The trick is, the date column you use needs to be something OUTSIDE the file, such as the “created date” column in the SharePoint library. What that means, is, this is only really useful for SharePoint folder sources, where Power BI is grabbing… Continue reading: Can you use incremental refresh on SharePoint file sources in Power BI?
The matrix visual in Power BI is a bit fiddly to work with, particularly when you’re working with text-based data. It likes to auto-summarize any text fields you add, and typically you want a little more control over the header groupings than it wants to give. Here’s an example of what the task data looks… Continue reading: How to Make Your Matrix Behave
In the video tutorials for how to send a basic HTML table from Power BI with Power Automate and similar for styled tables, a question came up about what to do if the query to the Power BI dataset returned blank for a given user – if it has no rows to show, it will… Continue reading: Sending HTML Table Emails from Power BI with Power Automate – Handling Blanks