Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
User | Count |
---|---|
84 | |
81 | |
72 | |
72 | |
55 |
User | Count |
---|---|
108 | |
105 | |
96 | |
86 | |
68 |