Filtering a true false

[Anonymous]

Hello All,

I am working with a column which only has False values. The datatype is true/false, but I want the graph to show that there are 0 true values.

The other column does include TRUE values.

Please let me know if you need more information.

Thanks in advance

[Anonymous · Accepted solution]

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.

[parry2k]

@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

[Anonymous]

• - 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?

[parry2k]

@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?

[Anonymous]

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)