Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Column Chart - measure based on axis value

We have Dynamics CE in our org and for measuring some metrics around it, we need to know the total number of licensed users for each month.   I have a systemsuser table which has these fields - Li...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    You need a distinct date table to do it and use SELECTEDVALUE() to replace your hardcode.

    Here is my sample result.

    Here is my test file for your reference.

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

You need a distinct date table to do it and use SELECTEDVALUE() to replace your hardcode.

Here is my sample result.

Here is my test file for your reference.