Forum Discussion

F_Reh's avatar
F_Reh
Icon for Post Patron rankPost Patron
10 months ago
Solved

Adding Legend to Stacked Bar graph distorting the %s

Good Afternoon,   I have following Stacked Bar graph (Diag 1):     When I add the Categories Band field to the legend (in order to show the break down within each bar) there seems to be a ...
Need Help
Show and Tell
Tips and Tricks
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    10 months ago

    Hi F_Reh,

    Thankyou for the followup.

    The expression SELECTEDVALUE(Parameter_HI[ParameterLabel], "Organisation Action/Client Action #") uses the string default so the measure has a predictable fallback when the slicer is empty or multi-selected. In the PBIX file, Parameter_HI is a disconnected table created using Enter Data, not the built-in Field Parameter. The disconnected approach is straightforward and works with the SWITCH wrapper to map the slicer label to the appropriate # or % measure.

    Additionally, please find attached a screenshot and a revised sample PBIX file that uses the Field Parameters feature, which may assist in resolving the matter:


    We hope the information provided will help resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

    Thank you.

F_Reh's avatar
F_Reh
Icon for Post Patron rankPost Patron
10 months ago

Thank you...In relation to your measure, why is "Organisation Action/Client Action #" passed in to SELECTEDVALUE(), as well in inside the RETURN statement ?

 

Selected_Measure_Value =
VAR sel = SELECTEDVALUE( Parameter_HI[ParameterLabel], "Organisation Action/Client Action #" )
RETURN
SWITCH(
  TRUE(),
  sel = "Organisation Action/Client Action #", [OrgClient_Count_Measure],
  sel = "Organisation Action/Client Action %", [OrgClient_Pct_of_Month],
  sel = "Organisation Action #", [Org_Count_Measure],
  sel = "Organisation Action %", [Org_Pct_of_Month],
  sel = "Client Action #", [Client_Count_Measure],
  sel = "Client Action %", [Client_Pct_of_Month],
  BLANK()
)
 
In your PBIX file is Parameter_HI a Field Parameter, or is it a simple Table ?
 
Am confused by the measure in your file, because I only made Field Parameters in the past by very simply inserting columns & measures:
 

 

Regards