Forum Discussion

NotMyJob's avatar
NotMyJob
Helper III
1 year ago

Display values >0 (line chart)

Is there a way to only display data in a table that is greater than 0?

I have 31 columns that define a category, and then on the X axis is my mmm/yyyy timeline.  There are so many lines on this that it's unusable.  I'm thinking if I can only show categories that are >0, it would be more readable.

 

If I have to write a separate expression for all 31 columns, I'm going to trash this and look for another method.

 

Thanks if anyone can help!

 

Need Help

2 Replies

  • uzuntasgokberk's avatar
    uzuntasgokberk
    Super User
    1 year ago

    Hello NotMyJob,

    You can filter on filter pane the measure or you can change y axis default value in visualization pane.

     

    Kind Regards,
    Gรถkberk UzuntaลŸ

    ๐Ÿ“Œ If this post helps, then please consider Accepting it as a solution and giving Kudos โ€” it helps other members find answers faster!

    ๐Ÿ”— Stay Connected:
    ๐Ÿ“˜ Medium |
    ๐Ÿ“บ YouTube |
    ๐Ÿ’ผ LinkedIn |
    ๐Ÿ“ท Instagram |
    ๐Ÿฆ X |
    ๐Ÿ‘ฝ Reddit |
    ๐ŸŒ Website |
    ๐ŸŽต TikTok |

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi NotMyJob ,

     

    Have you already solved the problem? If so, can you share your solution here and mark the correct answer as standard to help other members find it faster? Thank you very much for your co-operation!

     

     

    Best Regards,

    Clara Gong

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.