Forum Discussion
Login frequency group and users count
XuanHau , You need dynamic segmentation on measure
refer
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
Hi,
PBI file attached.
Hope this helps.
Hi XuanHau ,
In addition to amitchandak 's technical recommendations, there are also other ways to achive your required output, like for example, just utilizing calculated columns.
You can create calculated columns like below:
And then, you can create a measure like below from the calculated column above:
Distinctcount = DISTINCTCOUNT('Table'[What to count])
For the x-axis (field of number of times), you can also create a calculated column like below.
And put that on the stacked column chart to produce the same output you required.
I attach a pbix file as an example.
DataNinja777I also tried the way you suggested, but it works only if we use the slicer for one month. If we use multiple months or a date slicer, the results might not work well. I found another way to create the chart. Anyway, thank you for your ideas and help 👍
