Forum Discussion

gkir's avatar
gkir
Icon for Advocate II rankAdvocate II
4 years ago
Solved

Line and stacked column chart

Hi,

 

Is it possible for line and stacked column chart to show vertical line whenever I hover over the chart with the mouse like in the line chart?

In the line chart the vertical line appears:



But in the line and stacked column chart don't and it's really inconvenient because the tooltip is shown only when I mouse over the data point.

 

Also, I would like to know, is it possible to cut the weekends in these charts?
Categorical X axis isn't negotiable solution because I can't see all filtered period.

 

 

Can anyone help me?

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi gkir ,

     

    This measure will show 1 if the date is workday, and show 0 if the date is weekend. So we add this measure into viusal level filter and set it show items when value =1 to remove weekends. I think you you can try this way though you use continuous in X axis. It will still work.

    If this reply still couldn't help you solve your problem, please share a sample file without sensitive data with us and show us a screenshot with the result you want. This will make it easier for us to understand your requirement.

     

    Best Regards,
    Rico Zhou

     

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

4 Replies

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

    Hi gkir,

     

    To my knowledge you cannot have those funcitionalities that you are refering.

     

     

    In the line and stacked column chart you cannot set any line to be showned has in the line chart, regarding the question about filtering the weekends, if you do that the line will not be continuous, you cannot define any filtering at the day level when you are refering to points without any data has I assume you refer to weekends.

     

    When making the filtering of dates if you have 2 data points and a continuous axis the values in the middle will appear even without any values.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi gkir ,

     

    1. Is it possible for line and stacked column chart to show vertical line whenever I hover over the chart with the mouse like in the line chart?

    It seems to be set by design. If you don't want to see data labels by hover your mouse, try to turn on "Data label" function in visual format.

    2.Is it possible to cut the weekends in these charts?

    Try to create a measure and add this measure into visual level filter in your visual. 

    Measure = 
VAR _WEEKDAY = WEEKDAY(MAX(Sheet20[Date]),2)
RETURN
IF(_WEEKDAY IN {6,7},0,1)

     Then set it to show items when value =1. Result is as below.

     

    Best Regards,
    Rico Zhou

     

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

    • gkir's avatar
      gkir
      Icon for Advocate II rankAdvocate II
      4 years ago

      Thank you for your answer. But in your file X axis is categorical, not continuous. In my visual, if i change my axis to categorical, I cannot see all selected period and the scrollbar appears. Unfortunately, this solution is not appropriate for my data.

      .

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi gkir ,

         

        This measure will show 1 if the date is workday, and show 0 if the date is weekend. So we add this measure into viusal level filter and set it show items when value =1 to remove weekends. I think you you can try this way though you use continuous in X axis. It will still work.

        If this reply still couldn't help you solve your problem, please share a sample file without sensitive data with us and show us a screenshot with the result you want. This will make it easier for us to understand your requirement.

         

        Best Regards,
        Rico Zhou

         

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