on your colour Key
if you right click on blue you should get an option to exclude anything that is not red or green.
Hope it helps
Maybe you can create a set which only has the Green and Red Bar Charts. Then drag the set in the filter and choose to show members in set only.
To remove the empty space
change the field on the column shelf - The Y axsis to Discrete.
This should remove any space from the excluded bars.
Check to see if you have the option to show empty columns on - Turn off if you do.
Sorry but where do you find that option exactly? I right clicked on the pill and I did not see it. I also right clicked on the columns shelf and did not see it.
Actually I just found the section where the empty column option is located ( Analysis - Table Layout) but all of the options are unchecked or turned off. Is there something that should be done with the "advanced" option in Table layout?
Is it possible to share a sample workbook.
or even just the worksheet with the bar graphs on it.
You can copy and paste the sheet to a new workbook.
one more thing to try
Remove date from column
add your colour formula for min max to column
and add month to detail.
A little hard to know if this will work without being able to test on a sample workbook.
If you can create something that replicates the bar charts you have using superstore data,
That would help also
Khalid, you've been fantastic with your support. Unfortunately I can't share a sheet as my data is sensitive/protected client data and to recreate something with Superstore would probably be too time intensive and I'm not sure I could make it look this. I'm gonna have to take another approach with the visualization.
I do have a separate question regarding adding "N/A" to areas where there are no values present in my data. This is being used in a more simplified column version. Please see the visual below.
How can I add "N/A" wherever there is a blank space in my columns of values(percentages)?
I'm guessing this is the [PNP% of Total]
create calculated field
if isnull([PNP% of Total]) then 'N/A' else
str(Round(([PNP% of Total])* 100,2)) + ' %'
This may need slight tweaking to get your format correct.
But the idea is to do an if statement on your value to figure out where the nulls go and return everything as a string
Hope this helps
It shouldn't make a difference what field it is as the calculations are still being done on the same level of data
Create a calculated field as described using y/y% change
Let me know how you get on