How to update or create a measure to Power BI Premium Per user without having to publish entire dataset
Following on from my previous blog post How to complete granular deployment of Power BI Desktop changes to the Power BI Service (Using PPU), I want to also show how to update or create a measure in my dataset, where I can deploy this via ALM Toolkit. This now saves me from doing the following tasks previously: Time taken to…
Validating Power BI DAX measures when using Tabular Editor
I have really enjoyed using Tabular Editor with Power BI, as announced in the latest version of Power BI Announcing public preview of external tools in Power BI Desktop One of the challenges I have found is that it is very easy to create a new measure in Tabular Editor. Due to it currently not having any Intellisense I have…
DAX – Calculating the difference between 2 selections on a Slicer
Once again, I really enjoy answering questions on the Power BI Community, it keeps me challenged on how to find solutions to people’s requirements. This time the challenge was that a user on the forum was looking to calculate the difference between 2 selections made on a slicer. In this example the slicer was on a Product. Below is the…
Do you know how to use Multiple Disconnected Slicers in Power BI?
I had previously blogged Power BI – Using a Slicer to show different measures where I showed the steps on to have a different measure based on a slicer selection. I got a few comments from that blog post, where people were asking if it was possible to have multiple Slicers which could be used. If you are reading this…
Power BI – Using a Slicer to show different measures
I was on the Power BI Community where a question was asked how to use a Slicer to show different measures in a chart. I personally do it all the time, but after some searching trying to find a potential blog post to reference, I could not find anything suitable. So here is how to do it.
Power BI Desktop/DAX – Using Unicode (Arrows) as Measures in a Table
I was helping out in the Power BI Community and I came across the following requirement. The user had sales figures and based on the Previous month, they wanted to have an arrow showing if it was up or down. As well as if there was no data to say that there was no data. So this is how I…