top of page
The Journal of My Work
Sync Slicers & Sync Slicers Advanced Options
Power BI Bookmarks, Synced Slicers and Selections; these features transformed the way we report using Power BI. Now, most of the…
Summary of #LondonPowerBIDataViz December 2018
Happy New Year! Hope you all had a lovely time over Christmas and New Year period. My holiday started nicely with…
Visuals Level Slicers for A Slicer in #PowerBI
In my current project, one of the user requirement was to have a filter on the Year Slicer. To explain in…
Dynamic Legend in #Power BI Visual, Line Chart
It has been a while since I written a blog post, even my ten years old daughter started teasing saying “Motionless blog”,…
October and November #LondonPUGDataViz – UK Price Paid Data
My Power BI journey started with this dataset. Probably one of the most reliable open data source. Nicely formatted and very…
PowerApps and Sharepoint List-Identify which detail item has already been updated in PowerApps?
In one of my recent project, I did a fair bit of PowerApps. PowerApps was the front end, Share point list…
Dynamic Period variance with DAX in #PowerBI
One of those days where I spent a reasonable amount of time trying to solve a tricky DAX expression and once…
List.Repeat() in #PowerQuery to duplicate rows
Another quick, more of “Note to self” blog post. While I was working with FIFA Football Model, one of the queries…
Mass shooting data
For this month #LondonPUGDataViz, we are going to play with Gun violence archive data. This data is very interesting because it…
Adding a vertical line or marker to a chart in Power BI
A business user came to me asking “how can I get a vertical line on Line Chart in Power BI like…
Replace all numeric values in multiple columns using #PowerQuery
Learn how to replace all numeric values in multiple Power Query columns at once. A practical M language solution for data transformation in Power BI.
#PowerBI Audit log using #Office365 Management API
I love automating things, I have read somewhere, a good developer always tries to automate things, but in my case, I…
Where is my Power BI theme file?
Have you ever ended up in a situation where someone already did all the work to get the right brand colours,…
Split multiple columns into rows in #PowerQuery
Recently, I worked on an interesting problem. Datasource I was working with was a SharePoint list, working with SharePoint lists always…
Power BI Template to document the Power BI Service
Back in September, I promised I would write another blog post with a beautiful looking Power BI template. Even though I…
How I designed “Power BI Template to document the Power BI Service”
When it comes to writing, I have the least trust in my writing skills. I always wanted my blog to sound…
How to find all Power BI users in an organisation?
If you are the goto person for Power BI in your organisation, then I am sure at least once you may have…
Access Microsoft Graph API using Power BI
Recently I came across Microsoft Graph API through Power BI Custom data connectors documentation. Amazed by the amount of information provided…
SharePoint List Power BI Template
SharePoint is a killer; front end looks nice and beautiful. Once you start exploring behind the screens, that is when it…
Power BI Workaround – Drill Through Reporting in Power BI
So far I have seen many Power BI usage metrics demo’s or read blog posts about usage metrics, but not actually…
bottom of page