Forum Discussion

hiren89vora's avatar
hiren89vora
Frequent Visitor
4 years ago
Solved

Legend in Bar Chart

Hi,

 

Can anyone help with the legends in the bar chart. If nothing is selected in the slicer then it should pick type1 as the legend and if we select anyone or more then it should show type2 as legend.

 

 

Need Help
Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    hiren89vora , You Have Create mesure like

     

    =

    var _is = calculate(isfiltered(table[type]), allselected())

    return

    If(_is , [Measure], calculate([Measure], filter(Table, Table[Type] = "type 1" ) ) )

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI hiren89vora,

    For your scenario, I'd like to suggest you write a measure formula with an if statement and isfiltered function to check the selections.

    After these steps, you can use this measure on the value field to replace the raw field to achieve your requirement.

    ISFILTERED, ISCROSSFILTERED – DAX Guide - SQLBI

    If you are confused about the coding formula, please share some dummy data to test.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng