Forum Discussion
graphic formatting
- 10 years ago
Hi... sharing with you my attempt. This is not really a straight-forward solution, so this is more of a work-around to approximate the visualization preferred.
Basically, I've split the column with preferred conditional formatting (apologies, not sure which column, hence the sample snapshots are for either of the two) into 2 separate columns (or attributes), i.e. with (+) and (-). And then transformed the dataset using the 'unpivot' facility thereby converting the data-value columns into "attribute" and "value" data fields instead. Then charting them using the stacked columnar visual, with 3 rows set per month (1 row for the conditional columns/attribute, 1 for the fixed column, and 1 as buffer/spacer). The x-labels though are just plain text-box overriding the otherwise 'non-user-friendly' captions which are 'programmatic' labelling used to effect the grouping of stacked bars per month.
Just in case the sample pbix files are here and here.
Yes, but I wanted to make conditional formatting comparing a metric with the other
Hey walnei,
for or this you need to create a new measure that takes care of that I guess. Have you tried that?