Forum Discussion
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 sample data. How can i make a graph that would work with the selection of the "type"? Thanks in advance.
| Name | in | out | type |
| A | 2 | n/a | |
| A | 3 | n/a | |
| A | 5 | n/a | |
| A | 1 | TR | |
| A | 1 | TR | |
| A | 1 | AD |
9 Replies
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
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.
Use explicit measures ( and the "+0" trick if needed) or replace the nulls in your source data with 0
