Dax help or advice for visual

Hi mespiritu 

What does the meaning of only use "1" values to create the visual?

Maybe you can use COUNT() function to get the number of the "1" in one day.

Here for your reference:

First of all, I create a set of sample:

In power query, Transform > Select all the columns and click the Unpivot Columns:

Close & Apply:

The result is as follow:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.