Setting the Default Format String with Calculation Groups in Power BI
Recently I was working on a customer’s data and one thing that was missed was when something was not selected the Calculation Group did not return any default Format String. Below is how I solved this, with the tricky part being formatting of the measure to be displayed correctly. This follows on from my previous blog posts with regards to…
Quick tip on how to ensure your Format String Expression in the Power BI Calculation Group works
I was recently working on a more complex calculation group item and the corresponding Format String Expression. One of the things I did learn is that the Format String Expression is actually like any other DAX expression. It works in exactly the same way! How cool is that. Currently the only way to create and or edit the Format String…
Calculation Groups with Disconnected Tables in Power BI/AAS
Below I will explain how to use Calculation Groups with Disconnected tables. I know that some of this might be able to be done with other calculation groups. I find I have more flexibility when combining Calculation Groups with a disconnected table. Below are some of my previous calculation group blog posts that might also be of interest: Create Currency…
Power BI Visuals now support Custom Formatting for measures using Calculation Groups!
The Power BI team has been doing a lot of incredible work. The most recent update which I got wind of is Custom Formatting of measures is now supported for Visuals. This has already been deployed to the Power BI Service and if you download thelatest version of Power BI Desktop (Version 2.83.5894.961 as at 03 Aug 2020) it has…
Create Currency Formatting Strings using Calculation Groups in Power BI Pro & Premium / Azure Analysis Services / SQL Server Analysis Services 2019
Below are the steps on how I got the calculation groups to work for Currency formatting strings when the currency format string will be displayed per currency shown. Following on from my previous blog post (How to create and use Calculation Groups in Power BI Pro & Premium / Azure Analysis Services / SQL Server Analysis Services 2019) on how…
How to create and use Calculation Groups in Power BI Pro & Premium / Azure Analysis Services / SQL Server Analysis Services 2019
I have been reading some great blog posts from SQLBI.COM on using and implementing Calculation Groups. What I did find is that currently there is not step by step process on how to get this working. This is what I will do in my blog post below. As it stands today 29 April 2020 you can currently use calculation groups…