cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DBC
New Member

show a percentage of date entries against blanks in a column?!

Hi all, 

 

I want to show a percentage of date entries on a card. 

 

Column has 72 rows with 3 date entries. 

 

How do i get PowerBi to show the number of date entries against the blanks?

 

TIA 

4 REPLIES 4
lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Case referenceAMdate allowcated to AM       
1         
2JS01/01/2023       
3         
4         
5DB08/08/2023       
6         
7         
8         
9         

 

Hi, thanks for the reply! Sample data attached 

Trying to show a card graphic with the 'date allowcated' column as a percentage  of the overall entries by 'case reference' 

 

22% in this example 

for example

 

lbendlin_0-1685151264272.png

 

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors