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.
Hi Power BI Community,
Please can someone help me on how i can view the first 3 months of data:
basically each customer has a different starting date so i cannot use the slicer as this uses the entire date range from the first customer and the relative date filter only allows last not first.
Please can someone help
Thank You
Kunal
You can create a YearMonth column and then rank the YearMonth for each user. So that we can filter the first 3 months for each user easily.
For details, please refer to attached PBIX file.
YearMonth = YEAR ( Sheet1[Created Time] ) * 100 + MONTH ( Sheet1[Created Time] )
RankYearMonth = RANKX ( FILTER ( Sheet1, Sheet1[Account] = EARLIER ( Sheet1[Account] ) ), Sheet1[YearMonth], , ASC, DENSE )
Best Regards,
Herbert
thanks for your help, can you please tell me why you *100?
If your problem has been resolved, you can mark the right answer as solution so that other ones who have the same problem can find the solution quickly.
Best Regards,
Herbert
Just give a good format for the YearMonth column which data type is whole number, so that we can rank it correctly.
We can also not *100, but in that case, YearMonth will be 2016 +5 = 2021 instead of 201600 + 5 = 201605.
Best Regards,
Herbert
PLease see each customer has a different first created Time..
So i need to see the first 3 months of data for each customer.
Does that make sense?
Thanks
Try using the relative filtering. Drop your data into a table visual and make a slicer with customers.
Select the table and in visual level filtering ,select relative filtering and use bottom 90 /top 90 accordingly.
Can you share a screenshot of your data(sample data)..? It would be easy that way.
HI
thanks for getting back to me. I was unable to attach an excel file so i add to attach Screenshots,
So if you see cust1 has a diffrent first date then cust2 so on for cust3 and 4
Hi,
Your question is not clear and neither is your data. Paste a sample dataset, explain the business problem and show the expected result.
How do i upload a dataset?
Hi,
Just paste your data from the Excel file in the body of the message. Else, upload the file to google Drive and share the downlod link here.
Covering 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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |