Forum Discussion

marctiram's avatar
marctiram
Frequent Visitor
3 years ago

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...
measure
x-axis
daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
3 years ago

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's avatar
marctiram
Frequent Visitor
3 years ago

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's avatar
    daXtreme
    Icon for Solution Sage rankSolution Sage
    3 years ago

    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's avatar
      marctiram
      Frequent Visitor
      3 years ago

      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?

    • marctiram's avatar
      marctiram
      Frequent Visitor
      3 years ago

      Any help?