Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Line value missing from combination chart

  Here's my dataset, including a measure. The native dataset has numeric values by "statistic name". This is obviously ripe for a chart with "Statistic" as the column series.   I have a Total Empl...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  Anonymous 

I have tested on my side, it works well.

From your screenshot, you measure is ok, and in the combination chart, I find that the Y-axis column is start from 0 and end to 1.

 

So the problem must be that you have set the fixed value for Y-Axis of this combination chart

 

 

Regards,

Lin

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks very much for taking the trouble to reproduce the issue - I do appreciate it. You have confirmed for me that this actually works. (and I actually have a different tab where this works). 

     

    The Y axis is set to 0 to Auto. I tried hard coding to 100 it changed the X-Axis! (but no measure appeared)

     

     

    -If I move the measure to tooltips, the value appears correctly in the tooltip

    -If I change the visualisation to table, the measure is shown

    -If I click the measure and change "Show Values As" from "No calculation" to "Percent of Grand Total", the measure is shown (obviously not showing the value that I want)

     

    Maybe it has something to do with DAX + filtering the value but as that appears to be the main difference in all of this.

     

    My DAX is currently:

     

     

    Total Employees = CALCULATE(SUM(Statistics[Value]),FILTER(ALL(Statistics[Statistic]),[Statistic]="Total Employees"))

     

     

     

     

     

     

    • v-lili6-msft's avatar
      v-lili6-msft
      Community Support
      6 years ago

      hi  Anonymous 

      If possible, could you please share your sample pbix file for us have a test, there should be something wrong in other.

      You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

       

      Regards,

      Lin

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks again for sticking with this.

         

        I tried to reproduce the issue in a simple PowerBI report but I couldn't actually get to my original screenshot with the measure appearing in the table but not appearing in the chart.

         

        So I don't understand how I got the original screenshot in my question as I can't reproduce it now.

         

        Anyway I fiddled with the DAX and actually found that amitchandak  first suggestion was correct around the DAX. So I'll mark his answer as correct in this case - I hope you don't mind.

         

        To summarise, this DAX expressions do not give the required result

         

        Total Employees = CALCULATE(
    SUM(Statistics[Value]),
    FILTER(
        Statistics,
        [Statistic]="Total Employees"
        )
    )

         and this expression does:

        Total Employees = CALCULATE(
    SUM(Statistics[Value]),
    FILTER(
        ALL(Statistics),
        [Statistic]="Total Employees"
        )
    )