Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello there! I was wondering if someone can help me this chart I am trying to develop. The bar chart I am trying to create has the following:
x-axis = Min date of appraisal submission date
y-axis = count of appraisals
My table has rows for each submission date so I would only want to grab the earliest submitted date and count the # of appraisals submitted on that date.
Thank you in advance for your assistance.
Lovella
Sure, I can help you with that. You can use the DAX function MIN to get the earliest submission date and then use the COUNTROWS function to count the number of appraisals submitted on that date. Here's an example DAX formula: Appraisals Count = COUNTROWS(FILTER('Table', 'Table'[Submission Date] = MIN('Table'[Submission Date]))) Replace 'Table' with the name of your table and 'Submission Date' with the name of your submission date column. This formula will give you the count of appraisals submitted on the earliest submission date. You can use this formula in your bar chart's y-axis.
Hi @Lsh0576 ,
I created some data:
Here are the steps you can follow:
1. Create measure.
Flag =
IF(
MAX('Table'[appraisal submission date])= MINX(ALL('Table'),[appraisal submission date]),1,0)
2. Place [Flag]in Filters, set is=1, apply filter.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thank you for this. I realized that all of my formulas were solved via switching to import mode (from Direct Query..too much limitations). But I appreciate the assistance! Have a great day!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
12 | |
11 | |
10 | |
9 |