Showing posts with label Power BI. Show all posts
Showing posts with label Power BI. Show all posts
Wednesday, 13 November 2024

Replacing values in Power BI revisited

›
Back in 2022 I wrote a post detailing the various ways you can replace part of a string in M code (Power Query). It's actually the post...
Monday, 10 June 2024

Hacking PowerBI's Funnel Visual

›
This is a post I wrote specifically to support my entry to the Storytelling With Data's community monthly challenge for June, which is t...
Thursday, 19 October 2023

Vlookups in Power Query (for power BI)

›
If you're familiar with Excel before moving to Power Query then it's a little maddening to find that PowerQuery doesn't have a b...
Friday, 28 October 2022

Add extra rows in Power Query dependent on value in cell/column

›
If you're working in Power Query, and you need to add a whole bunch of blank rows, or rows based on the value from another column. How d...
Thursday, 20 October 2022

How do you sum a total for a column in Power Query?

›
Power Query has a "Count Rows" button, but there's no equivalent button for when you want to quickly get the total of your val...
Friday, 1 July 2022

How to Differentiate Between Similar Field Entries

›
Say you run a series of events and want to display registration, attendance etc on a bar chart in Power BI. The length of the event names an...
Wednesday, 25 May 2022

Joining/Merging Columns in a single step

›
As per my previous post sometimes, for tidiness you just want to do something in a single step. So how do you do this with merging / joining...

Remove/Replacing part of a string in Power Query

›
If you like keeping things neat and understandable in Power BI then you probably like to minimise things to one line. So there are times whe...