Workaround | Measure as x-axis

[marctiram]

Hi everyone,

I am monitoring the adoption level of an application.

Overall, I have a table that capture the user name and dates when they connect to the app so I can deduce how often they use it and classify them by frequency type "high", "medium","low".

However, I do not reach to display the measure I created as X-axis and it seems it is not possible so I try to find a workaround - but still have not found it...

Any suggestions? I attached an excel that illustres what I try to do as well as my PowerBI draft then. Thanks a lot!

Excel illustration: https://easyupload.io/82x39b

PowerBI draft: https://easyupload.io/monkm2 

[marctiram]

Any support?

[daXtreme]

On the x-axis you can only place columns, never measures (with the exception of the scatter chart, I think). So, create a dimension where you'll store all or a selection of the measure's expected values and voila! You'll be able to use the values on the axis.

[marctiram]

Thanks a lots for the quick support! Just not sure what you mean by "create a dimension and store the measures". Do you refer to a new table with measures as columns? I tried something like this but it was not working either. Might you share some more details to better understand which workaround you suggest?

[daXtreme]

Dimensional modeling is the heart of Power BI. If you don't know what it is... well, my advice is you should learn it rather sooner than later. Here's something to get you started.

By the way, I did not say "create a dimension and store the measures." I said "[...] where you'll store all or a selection of the measure's expected values." That's a very important difference.

[marctiram]

Any help?

[marctiram]

I watched the video and I understand what you mean by dimensional modeling now but still struggling to understand how to apply it to my needs in order to report the number of users by level of application use. Would you have some concrete examples I could use as reference for similar things for instance?