Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We launched a new platform last year, and I want to show a line graph showing the % of users who used it each month.
I have 2 tables one with all user information and one with usage information
This counts active users in a given month from User Table:
This counts monthly users from Dashboard Table:
For instance March 2023 should be 43% not 33%
I have a date table that I created off of dates in the user table, and I am using the date heirarchy month and year from the date table in the MonthlyUserCount:
The New Dashboard table has subscription dates with Month and year heirarchy, and thats what is being used as the filters on the Other table
In the Data Model, the date table is not linked to anything.
I feel I am missing something here.....
Hi @Jtischler ,
Not really sure how you have your model setup but seems to be a discrepancy between the dates since the date table is a separate table from the model when you try and make the calculations based on it without any relationship the values get a different context so a different result.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |