Forum Discussion

IF's avatar
IF
Post Prodigy
3 years ago

Graph with special structure

Hi, I would like to make a graph from this data. I want to use the type as the selection, but it doesn't work if i select it due to the data structure. I have quite a lot of data, but this is a samp...
Need Help
lbendlin's avatar
lbendlin
Super User
3 years ago

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

  • IF's avatar
    IF
    Post Prodigy
    3 years ago

    When I don't select anything, the graph is right. the line shows 3 and the bar shows 10. If i select the TR in the slicer, I want to see the line as 2. Similarly if i select "AD" in the slicer, the line should show 1. However, if i select any of these options, the graph doesn't show the data.

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      Use explicit measures ( and the "+0"  trick if needed) or replace the nulls in your source data with 0