Loading...

Two Number Formats, One Column – WHAT!

Two Number Formats, One Column – WHAT!

Have you ever wished to have two different number formats in just one column within Power BI? Well, you're in luck because this tutorial explores just that! This seemingly tricky feature would be particularly handy in P&L reports where it is necessary to display different types of currencies in a single column. But it also has a wide scope of other applications.

In 2016, the idea was pitched at ideas.powerbi.com and has been realized since then. This tutorial takes you through the entire process of presenting data on Power BI with dual number formats in a single column. It involves some technical skills but nothing too complex. With a step-by-step guide, you can easily adopt this feature, and revolutionize the legibility and practicality of your Power BI sheets.

So let your reporting mojo shine, and follow this tutorial to distinguish your Power BI reports from the rest!

Read More »

Published on:

Learn more
Power BI Live Training - Power BI Online Training - Excelerator BI
Power BI Live Training - Power BI Online Training - Excelerator BI

Australian Power BI training ✅ Power BI online training ✅ Learn Power Query online ✅ Power BI expert, Matt Allington (MVP) ✅ Best in class Power BI book

Share post:

Related posts

on object formatting in Power BI by taik18

If you're looking to master object formatting in Power BI, look no further than this informative video tutorial by taik18. In this tutorial, t...

2 years ago

Format String Calculation Groups In Power BI P&L Statements

If you want to improve your skills in creating and formatting string calculation groups in Power BI for Profit and Loss (P&L) statements, ...

2 years ago

Expression Builder: Applying Conditional Formatting On Paginated Reports

Learn how to apply conditional formatting in your paginated reports with this tutorial. You'll be using the Expression Builder and Placeholder...

3 years ago

Report Builder In Power BI: Formatting Objects & Visualizations

If you're interested in using Report Builder in Power BI to create paginated reports, this tutorial is just what you need. In this guide, you'...

3 years ago

Upgrading Your Data Labels With Conditional Formatting!

This video tutorial teaches you how to improve your data labels using conditional formatting. Whether you're a data analyst, spreadsheet guru,...

3 years ago

NEW! Improved Formatting of Data LABELS in Power BI

In this video, you'll learn about the enhanced conditional formatting feature for data labels in the recently released August 2022 Power BI up...

3 years ago

Apply Conditional Formatting on Power BI Data Labels

In this informative video, you'll discover how to effectively apply conditional formatting to your Power BI data labels. With this technique, ...

3 years ago

Insights Unlocked using Conditional Formatting in Power BI (with Pragati Jain)

In this insightful video, Pragati Jain shares some useful tricks that can help you make the most of conditional formatting in Power BI. By lev...

3 years ago

SharePoint List Formatting – Column Formatting Samples

SharePoint List Formatting provides the opportunity to format list columns in modern lists and libraries, enhancing user experience for those ...

3 years ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy