Forum Discussion
Infinity in two different ways
Hi All,
First time writing here, I hope you can help me.
Short explanation: I have a KPI that can be infinity in some situations, it's not wrong and i don't want to show it as BLANK or ZERO because it has different meaning on report. I have two charts for same KPI and one shows the infinity as a high bar and all rest of values as "0T%" with bar having no size. But if i select this infinity bar in this chart the second chart shows the infinity as a big bar but with no changes on other values.
Basically it means that if I select one infinity bar in any chart the other charts will show the infinity without disturb the other bars.
Gray data infinity is comparable with 126%
Blue data (infinity is selected) is changing everyhing else to 0T%.
I would like to have the infinity always like the Gray chart. Any idea how? I try to create a slicer and select this infinity case but than it makes both charts as the blue....
1 Reply
- lbendlinSuper User
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.