Forum Discussion
HamidBee
Power Participant
4 years agoHow do I create a Dynamic Report Title for the possible scenarios?
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 lik...
- Anonymous4 years ago
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
PijushRoy
Community Champion
4 years agoHi 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
HamidBee
Power Participant
4 years agoThank 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.