1 ACCEPTED SOLUTION
Hi @achand ,
You can make a No row exist in your fact table but appending a row or you can create a separate Yes/No dimensions table and relate to fact. You then use this dimension column in your bar so you'll have the option to format the bar for No. Please refer to the attached pbix for details.
Hi @achand ,
You can make a No row exist in your fact table but appending a row or you can create a separate Yes/No dimensions table and relate to fact. You then use this dimension column in your bar so you'll have the option to format the bar for No. Please refer to the attached pbix for details.
I've attached a snippet below to provide clarity on the matter. Below there's a stacked bar chart with a Legend added on the second chart, while the first one lacks it. Interestingly, I can modify the color of the bars on chart without Legend, but I'm encountering difficulty in changing the color on the chart with Legend.
Yes I know, but when there's no data available for the NO category, attempting to change the color for the YES category is restricted. Despite the restriction on changing the color for the YES category when there's no data available for the NO category, I found a workaround. I created a separate table with values for the NO category, appended it to the main table, and this successfully resolved the issue. However, if there's an alternative solution available, I would greatly appreciate it.
Thank you so much!
I did mention appending an extra row in my initial reply. Also using a separate dimenions table would have also worked. In the pbix I attached, No doesnt exist in fact but in the dimensions table so you can still format the No in the dimensions table as it exists there. You'll just have to use the column from that table instead and enable show items with no data before formatting the legend.
