Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am working with the following data:
Area | Values |
A | 45 |
B | 34 |
C | 87 |
D | 56 |
E | 97 |
F | 34 |
G | 21 |
I have plotted a simple bar chart to illustrate this data. I would like to have a dynamic title that does the following:
1) If none of the bars are selected it simply reads: "Total Number of Transactions".
2) If one bar is selected it reads: "Total Number of Transactions in Zone _". The underscore here would be replaced by the letter.
3) If two bars are selected it reads: "Total Number of Transactions in Zones _ & _".
4) If three or more bars are selected it reads "Total Number of Transactions in Zones _ , _ & _ ". And so on.
Please find attached a link of the file which I am sharing here:
https://www.mediafire.com/file/npqmq5g0rm619xc/Sample_Data.pbix/file
Any help would be greatly appreciated.
Solved! Go to Solution.
Hi @HamidBee ,
Here are the steps you can follow:
1. Create measure.
1&&7 =
var _discount=DISTINCTCOUNT(Data[Area])
var _max=MAX('Data'[Area])
return
SWITCH(
TRUE(),
_discount=7,"Total Number of Transactions",
_discount=1,"Total Number of Transactions in Zone"&" "&_max)
2&&6 =
var _discount=DISTINCTCOUNT(Data[Area])
VAR _area = CONCATENATEX(
VALUES(Data[Area]),Data[Area],",")
var _len=LEN(_area)
var _replace=
REPLACE(_area,_len-1,1,"&")
return
"Total Number of Transactions in Zones " & _replace & ""
True =
var _discount=COUNT(Data[Area])
return
IF(
_discount in {1,7},[1&&7],
[2&&6])
2. Result:
Sovle1:
Sovle2:
Solve3:
Solve4:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @HamidBee ,
Here are the steps you can follow:
1. Create measure.
1&&7 =
var _discount=DISTINCTCOUNT(Data[Area])
var _max=MAX('Data'[Area])
return
SWITCH(
TRUE(),
_discount=7,"Total Number of Transactions",
_discount=1,"Total Number of Transactions in Zone"&" "&_max)
2&&6 =
var _discount=DISTINCTCOUNT(Data[Area])
VAR _area = CONCATENATEX(
VALUES(Data[Area]),Data[Area],",")
var _len=LEN(_area)
var _replace=
REPLACE(_area,_len-1,1,"&")
return
"Total Number of Transactions in Zones " & _replace & ""
True =
var _discount=COUNT(Data[Area])
return
IF(
_discount in {1,7},[1&&7],
[2&&6])
2. Result:
Sovle1:
Sovle2:
Solve3:
Solve4:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @HamidBee
Please try this
I like the idea however the ampersands (&) are missing in conditions 3 and 4.
Hi @HamidBee
You can change the text format as per your requirement.
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos
Thank you but I Think the code will need some considerable adjustment inorder to achieve this. At the moment the code you have provided doesn't fall in line with my 3rd and 4th requirement. But thanks anyway.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |