Forum Discussion
Solved
How do I label missing data?
Two tables involved: Contracts and Contract Evaluations. One Contract has many evaluations (one each month) An evaluation can be one of three types - draft final or approved. How do I create ...
I added a calculated column to my 'Contracts' table using the following code (I have attached a PBIX file)
Type = VAR x = CALCULATE(MIN('Evaluations'[Type]),RELATEDTABLE('Evaluations')) RETURN IF(x="","Missing",x)Then dragged the new column to a pie chart twice as follows
Where would you like to show the "Missing" value? In a new column in the 'Contracts' table? or somewhere else?
The end game is a visualisation., let's say a pie graph.
The pie, (100%) shows all the evaluations. There will be four categories. draft final or approved..... and > Missing <.
One slice of the pie is, for example, "3% of evaluations are missing"
Nope.
Can you please mock up some sample data that looks like your data and post here. I'm sure we can get this working for you.