Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Power BI

Hello Community!

I am trying to visualize some of a column's values, as fixed values of a line chart, and then only plot the other values when selected in a slicer

for example a column containing letters from A to Z, I want to plot letters from A to F using a line chart, and the rest of values will only be plotted if selected

without filtering out the letters from A to F 

Thank you in advance for your help 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Create a new column

     

    If([Column] in {"A","B","C", "D", "E", "F"} , "A-F",[Column]) 

     

    Now using this you can select A-F always in slicer