Forum Discussion
Workaround | Measure as x-axis
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!
6 Replies
daXtremeSolution Sage
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.
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.
Any support?
