Power BI Report using Calculation Groups to switch different measurements
You will also note that the countries are separated out using the small multiples visual allowing the information to be clear and easily understood.
This second page of this report allows the user to also then choose which measurement they want to look at – Sales, Quantity, Cost or Profit. Again there is the ability to choose which value you want to highlight and the information is separated by country to give clear concise visuals. You’ll notice that the Sales Amount, Cost and Profit are all formatted as currency whereas the Quantity is a whole number.
Tabular Editor is a development tool that you can use for Power BI reports that give you as a developer the power to create reports that achieve the below.
Most of the reports I work on are commercially sensitive, however, I find this initiative by a group of amazing data evangelists really help develop the visual aspects of Power BI but also give a chance to showcase what Power BI can do.
Keeping current and up-to-date is essential in this industry, and this is an excellent way to do this visually
Any questions, happy to help,
Sue