Forum Discussion
Power Bi Line Chart Show Percentage per x-axis category instead of Grand Total
- 2 years ago
Neqom , Assume you have two measures ontime and total PO
Then it should be a measure
% = Divide([OnTIme], [Total PO])
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Neqom , Assume you have two measures ontime and total PO
Then it should be a measure
% = Divide([OnTIme], [Total PO])
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
I don't have any measures. The fields "Po Number","Requested Date" and "Status" are fields in the same table.
https://drive.google.com/file/d/1On1AZt6bgkuPCWmhoegZ5LNs3xmhUIFI/view?usp=sharing
There it is sample data with those 3 columns. PO Number appears multiple times since every PO number has multiple lines.