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.
Dear all,
@Anonymous
i was attempting to tweak a meaure to get some desired result
as you see below, the boxes i have used to create enter values, however when i am entering the the Donut chart is not updating or summing it up.
is there a way to fix that?
here is my sample pbix
https://drive.google.com/file/d/1IlwR9wQJqQIQ0o2P5hsnouhEWS_StDdz/view?usp=sharing
Solved! Go to Solution.
Create another measure as follows for this kind of visuals that have multiple values for Expat/National like "Manager", "Director" and so on .... (But don't delete the current measure. You will need it for other scenarios)
FY21 Scenario Closing Projection HC Expat_National V2 =
VAR __raw = [Latest HC] + [Preboarding Pipeline] + [Additional approved Exp Hire] + [Additional Approved Graduate] - [Confirmed Exists] - [Exit Pipeline]
VAR SumExpatValues = [Expat_ED Value]+[Expat_M Value]+[Expat_P Value]+[Expat_S Value]+[Expat_S/A Value]+[Expat_SM Value]
VAR SumNationalValues = [National_ED Value]+[National_M Value]+[National_P Value]+[National_S Value]+[National_S/A Value]+[National_SM Value]
VAR X =
SELECTEDVALUE ( Nationality[National/Expat_P] )
RETURN
SWITCH (
SELECTEDVALUE ( Nationality[National/Expat_P] ),
"Expat", SumExpatValues,
"National", SumNationalValues
) + __raw
Create another measure as follows for this kind of visuals that have multiple values for Expat/National like "Manager", "Director" and so on .... (But don't delete the current measure. You will need it for other scenarios)
FY21 Scenario Closing Projection HC Expat_National V2 =
VAR __raw = [Latest HC] + [Preboarding Pipeline] + [Additional approved Exp Hire] + [Additional Approved Graduate] - [Confirmed Exists] - [Exit Pipeline]
VAR SumExpatValues = [Expat_ED Value]+[Expat_M Value]+[Expat_P Value]+[Expat_S Value]+[Expat_S/A Value]+[Expat_SM Value]
VAR SumNationalValues = [National_ED Value]+[National_M Value]+[National_P Value]+[National_S Value]+[National_S/A Value]+[National_SM Value]
VAR X =
SELECTEDVALUE ( Nationality[National/Expat_P] )
RETURN
SWITCH (
SELECTEDVALUE ( Nationality[National/Expat_P] ),
"Expat", SumExpatValues,
"National", SumNationalValues
) + __raw
@Anonymous
i noticed that above measure will not work for "Card visual"
is there anyway to fix that?
@Anonymous
Worked like charm, its so helpful, i took whole day figuring this out.
thanks so much
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 |
---|---|
107 | |
106 | |
78 | |
72 | |
67 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |