Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

3 Measure use as slicer

I've created measures like PY and CY and using these measures as parameter

parameter using as slicer so I applied color condition based on values in barchart like less than 0 then red more than 0 green.

hence parameter doesn't support me becasue I need to apply selection filter. How to apply Here is is sample measures

 

Parameter = {
    ("CY", NAMEOF('Measure'[CY]), 0),
    ("PY", NAMEOF('Measure'[PY]), 1),
 
Parameter_Color =

SWITCH(TRUE(),

[PY]>0,"Green","Red"
[CY]>0,"Green","Red"

 

How we need to determine which measure is selected and then assign it to the variable and apply color conditions based on a variable value and how to apply DAX formula like Selectedvalue filter for these measures then apply condition color, suggest.

 

Thanks!

 

 

Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    Hi Anonymous ,

    Could you provide some sample data along with the expected output? That would make it easier to pinpoint the issue and refine the solution accurately.

     

5 Replies

  • sanalytics's avatar
    sanalytics
    Icon for Super User rankSuper User
    1 year ago

    Anonymous 

    Can you see the below measure works for you or not. if it is not working the i request you to provide some dummay data along with your desired output. This can help us to provide complete solution.

     

    Color Measure = 
VAR _SelectedMeasure = SELECTEDVALUE('Measure Parameter'[Measure Parameter])
VAR _Value = 
    SWITCH(
        _SelectedMeasure,
        "CY", [CY],
        "PY", [PY]
    )
RETURN
    IF(_Value > 0, "Green", "Red")

     

    Regards,

    sanaltyics

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      its giving result as error

       

      • V-yubandi-msft's avatar
        V-yubandi-msft
        Icon for Community Support rankCommunity Support
        1 year ago

        Hi Anonymous ,

        Could you provide some sample data along with the expected output? That would make it easier to pinpoint the issue and refine the solution accurately.

         

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi Anonymous ,

    We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.

    Your feedback is valuable to us, and we look forward to hearing from you soon.

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi Anonymous ,

    We wanted to check in and see if your issue has been resolved. If so, we’d appreciate it if you could share your solution or workaround and mark the appropriate response as the accepted answer. This helps other community members facing similar challenges find solutions more quickly.

     

    If we don’t hear back, we’ll go ahead and close this thread. Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

     

    Yugandhar – Community Support Team