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.
Hello everybody,
as you can see from the picture below, I cannot show %contacted or %testdrive out of the leads. I can only show them as % of their own grand total. Is there a way to insert perhaps a tooltip to show %contacted out of leads?
Please mind that in the source data, values are binary data.
Thanks in advance.
Cheers,
Andrea
Solved! Go to Solution.
Hi @Anonymous
did you try creating a measure like
%Leads contacted = DIVIDE( SUM(Table[Contacted]), SUM(Table[Leads]) ) * 100
?
HTH,
Frank
Hi @Anonymous
did you try creating a measure like
%Leads contacted = DIVIDE( SUM(Table[Contacted]), SUM(Table[Leads]) ) * 100
?
HTH,
Frank
Hi Frank!
That's a great tip! Thanks a lot!!! Is there a way to show it with the % symbol next to the number?
Moreover, how do Measures work? When they are set, if I change the data source (wih an up-to-date file) will work anyhow?
@Anonymous
sure, just remove the "*100" from the formula, and under the "Modeling" ribbon, format the measure as Percentage.
The beauty of the measures is that they're always calculated dynamically - so whenever you load new data, or even just change a filter, or add an additional dimension to your visual the measure is recalculated and will always adjust 🙂
HTH,
Frank
Thx a lot Frank. That helped a lot.
I thought that measures were changing every time a new file was uploaded. That's why for make them permanent I often used the "edit query" option.
Thanks again.
Cheers,
Andrea.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |