Problem: I need to hide data elements in a column combo chart below X number, due to statistical de-identification requirements for protected health information. Conditional formatting works to "hide" the column value, but not the line values nor labels. The BU doesn't prefer the easy solution of filtering using show when >= X number, because that removes those Months from the X-axis.
Context: mutliple clients receive an identical report, but any given month different elements of a viz may need to be hidden based on the above rules. I must use Direct Query, and I cannot publish to the server; these reports are exported to PDF. Currently, I have a synced slicer to filter through the client list.
Solutions I have tried:
1) conditional formatting (not available on line of combo chart)
2) RadCad's RLS tutorials
3) aggregate table
Any thoughts on workarounds I have missed or better approaches are welcomed. Thanks in advance!
