Forum Discussion
Filtering a true false
There is not enough Data.
Because the data I am reporting on is constantly changing, it will be better to wait for more data so that reporting can be more accurate.
The true false column which I was talking about will at one stage have both TRUE and FALSE values. Then it will display accurately.
While I'm waiting for this data, I'm using a waterfall chart per column to show the progress.
Anonymous sorry your question is not clear, Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
- - I have three columns
- BA Done
- Frontend Done
- Backend Done
- All columns are of the TRUE/FALSE datatype
- BA Done has values for both TRUE and FALSE
- The other two columns only have values for FALSE
- When adding a visual filter for the BA Done column, I can filter on TRUE or on FALSE.
- When adding filters for the other columns, I can only filter on FALSE
- I want the visual to show that, on this TRUE/FALSE column, there are no TRUE values.
Does this make sense?
Anonymous if you want to show the true value from a columns that doesn't exists, it is not possible but if you want to show true/false both on a graph or other visual, it can be done, so what is your requirement? You want to show true/false both in visual level filter or in visuals?
Hello parry2k ,
Yes, I want to view it on a graph.On the y-axis, I have the amount of values that are TRUE
One the x-axis, I have the month of when this was changed.
Currently, the filter is applied on the BA Done column, but the other columns show distinct count of the whole column (1)
- - I have three columns