Forum Discussion
Show Missing Values in Matrix as Text
Hello,
I'm creating a dashboard for monitoring whether documents are up to date in our database (web based, linked via API) and can't figure out a way to show missing data as missing.
Data:
Rows that include document name, parent, as of date, and a document tag (ex: "ADV"). There can be multiple versions of the same document so I just use the one with the most recent as of date. There are also many rows in this data that aren't relevant for monitoring.
To conditionally format the data I use a column in power query to take the amount of days since the document as of date and assign good/warning/late depending on the type of document. In combination with this I have a simple pie chart that shows the % in good/warning/late.
Some documents may not be in the database, or not tagged appropriately and leading to blank rows in the matrix and an inaccurate representation in the pie chart.
Is there a way to assign a "missing" value to these rows if no document with the appropriate tag appears?
8 Replies
Can you provide your input ? There are several ways for that 🙂
Do you mean the file itself? Or what a row in power query looks like?
If you mean power query, the format is at follows:
parentID/documentType/Document Versions.asOf/DateDiff (today-as of date)/OverDue (assigned depending on document type and date diff)
Matrix:
I use first OverDue so that I only show the most recent document version
The file itself please, help us to help you.
Anonymous Hello ,
You can update conditional column as you have 3 values already like Good, Late and Warning so you can add not available when you do not have values or blanks or you desired output.
Kindly refer below image.
Thanks
Harish M
