Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
hello everyone ,
i have a facebook ads by campaign table
Campaign | Impressions |
Camp A | 1500000 |
Camp B | 100500 |
Camp C | 1000 |
Camp D | 10000 |
i want to make a column chart that will show me the campaign in the x-axis and measure of Total impressions
Total impressions = sum(table[impressions])
when i turn on data labels , i want to show a dynamic data label
so if number is in millions it will return 1.00M if the numbe rin thousands then it will return 1.00k
so new format should be i will show in table for better context
Campaign | Impressions |
Camp A | 1.5M |
Camp B | 100.5k |
Camp C | 1.00K |
Camp D | 10.00K |
Solved! Go to Solution.
@eliasayyy , Try like
SWITCH ( TRUE() ,
[Impressions]>= 1000000000 , FORMAT ([Impressions]/1000000000, decimal) & "bn" ,
[Impressions]>= 1000000, FORMAT ([Impressions]/1000000, decimal) & "M" ,
[Impressions]>= 1000, FORMAT ([Impressions]/1000, decimal) & "K",
FORMAT ([Impressions] , decimal)
)
@eliasayyy , Try like
SWITCH ( TRUE() ,
[Impressions]>= 1000000000 , FORMAT ([Impressions]/1000000000, decimal) & "bn" ,
[Impressions]>= 1000000, FORMAT ([Impressions]/1000000, decimal) & "M" ,
[Impressions]>= 1000, FORMAT ([Impressions]/1000, decimal) & "K",
FORMAT ([Impressions] , decimal)
)
Actually with the dynamic formating you don't need to use division.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |