Forum Discussion
Helper IIChange KPI display from Negative to possitive
Hi,
I want to change the percentage value from negative to possitive instead because the KPI measure here is on time field againt the target. So 18/27 should reflect the on time KPI at 66%. below it seam to show only the last value which is 8/13 = 62% but here it show -38%. I saw a post to add DAX in power bi desktop but I am using bi service due to connection to Onedrive as a data source others can update the database.
You should build your reports in desktop, not service. Read why at my blog here http://exceleratorbi.com.au/top-10-tips-getting-started-power-bi/
click on the formatter tab (paint roller). You would see an option to change the direction of tpwhat constitutes good and bad. Can't remember what it is called, but it is one of the first few
In this scenario, since the trend is descending, it supposes to display a negative value. This is by design in visual. Without using DAX to create another field, I don’t think you can get the positive values displayed in visual. I notice that you are using a custom visual for KPI published by Anonymous. So I would suggest you to add a request to him in the comments here, so that this custom visual may have an option to show negative for KPI in future.
Regards
Thank you Matt, Will take this in consideration
3 Replies
- MattAllington
Community Champion
You should build your reports in desktop, not service. Read why at my blog here http://exceleratorbi.com.au/top-10-tips-getting-started-power-bi/
click on the formatter tab (paint roller). You would see an option to change the direction of tpwhat constitutes good and bad. Can't remember what it is called, but it is one of the first few
manoplaeliThank you Matt, Will take this in consideration
v-ljerr-msftMicrosoft Employee
In this scenario, since the trend is descending, it supposes to display a negative value. This is by design in visual. Without using DAX to create another field, I don’t think you can get the positive values displayed in visual. I notice that you are using a custom visual for KPI published by Anonymous. So I would suggest you to add a request to him in the comments here, so that this custom visual may have an option to show negative for KPI in future.
Regards