Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I have a Histogram where I'm plotting the counting of a Id vs "creation_date".
This Id can also have a state: active, inactive, removed.
I would like to plot on the same histogram the counting of all ids, the counting of active ids and inactive ids.
Probably I should create a DAX formula but my question is: is it possible to make it from Power Bi service, so without any use of DAX?
Thank you
Solved! Go to Solution.
You need to create a measure in the desktop. We can't model it in the service.
You need to create a measure in the desktop. We can't model it in the service.
You're probably right that DAX would be the preferable solution for this
If you need to do it without DAX, maybe creating artificial rows in your data to count the All or unfiltered results might work. Simple example below
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |