Forum Discussion

Urrrshurrr's avatar
Urrrshurrr
New Member
1 year ago
Solved

Linking Vertical List Selections

Hello All,   I apologize if this is a fairly basic question, but I cannot seem to find an answer.   Background; Data is pulled from a Dynamics 365 Business Central server.  The only values that...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Urrrshurrr ,

     

    Based on your description, you want to also display #4460C in the bar graph when the user selects #4460. We can recognize #4460 as a parent category, create a custom table and measures, and determine if the #4460C in the current row contains the selected parent category. DAX reference: CONTAINSSTRINGEXACT function (DAX) - DAX | Microsoft Learn

     

    Step1. Custom table.

    test = VALUES('Table'[accountNumber])

     

    Step2. Measures.

    SelectedAccNum = 
VAR _selected = ALLSELECTED('Table'[accountNumber])
RETURN IF(MAX('test'[accountNumber]) IN _selected || CONTAINSSTRINGEXACT(MAX('test'[accountNumber]),SELECTEDVALUE('Table'[accountNumber])),1,0)

    Separate measure need to be created for bar graph value display.

    SumValue = CALCULATE(SUM('Table'[Value]),ALL('Table'),'Table'[accountNumber]=MAX('test'[accountNumber]))

     

    Step3.Apply Filter to control the bar chart column display.

     

    The output.

     

     

     

    Best regards,

    Mengmeng Li

Urrrshurrr's avatar
Urrrshurrr
New Member
1 year ago

Thank you ToddChitt and Anonymous !

 

The options suggested by both of you make sense and I'm sure one of them will work for my situation.

I will do some testing and report back with which option ended up being the best for me!

 

Thanks again.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Urrrshurrr ,

     

    How is the situation now? If the problem has been solved, please accept the replies you find helpful as solutions.

     

    Best regards,

    Mengmeng Li