Forum Discussion
PIA chart legend including zero value
Hello All,
The data has no "D" value so its count is zero and PIA chart has not it in the legend. But I want to have "D" value in the legend so that viewers find the "D" value in this report is zero. How is it possible?
Hi koorosh
The logic of 0 and "no value" is not always the same.
0 is a value that is equal to 0, no value can be just because of a lack of data, no transactions, etc...If you want to see the categories without values in the legend of the graph, you should modify the option "show items with no data " on the legend.
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
Gi koorosh
You need a dimension table with a unique value of all the categories and use this table column as a legend.the pix attached to my previous solution has all these steps, please download and follow.
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
3 Replies
Hi koorosh
The logic of 0 and "no value" is not always the same.
0 is a value that is equal to 0, no value can be just because of a lack of data, no transactions, etc...If you want to see the categories without values in the legend of the graph, you should modify the option "show items with no data " on the legend.
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
Thank you Rita. The raw data is as following.
The report is PIA chart that counts the content. But sometimes there is "D" value in the data and sometimes there is no "D" value in the raw data.
Now we want the legend of PIA chart shows "D" value in both scenarios.Gi koorosh
You need a dimension table with a unique value of all the categories and use this table column as a legend.the pix attached to my previous solution has all these steps, please download and follow.
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
