True False

[Corissandageri]

Hi Everyone

I have made a line graph from a Sharepoint list which tracks the daily water usage of our plant which I populate via a powerapp. But I also have a Yes No column in my list which I toggle which depends on certain parts of the plant runnning. How would I make that show in my graph? So to recap, every day I walk the plant and take a water reading from five different locations and toggle yes or no to indicate whether part of our plant is running or not.

Thank you

[v-cazheng-msft]

Hi, @Corissandageri 

Are the last two columns actual columns in your table or the measure you want? Can you provide a sample removing sensitive data or make it clearer?

Best Regards,

Caiyun Zheng

[amitchandak]

@Corissandageri , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Can you try measures like

countrows(Filter(Table, Table[toggle]))

countrows(Filter(Table, Table[toggle] = "True"))

[Corissandageri]

Hi amitchandak

Not quite in the format you asked for. I'm just now looking up Measures.