Forum Discussion
Helper IIIgraphic formatting
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.
Helper IIIAlguém consegue ajudar?
Voce Puede poner formato condicional.. Jejejej fale en 3 idiomas, con algunas palabras en portuñol!'
- walnei
Yes, but I wanted to make conditional formatting comparing a metric with the other
- fabianhenzler
Advocate I
Hey walnei,
for or this you need to create a new measure that takes care of that I guess. Have you tried that?
- walnei
fabianhenzler , thanks but this tutorial does not help me . The precise format that is comparing two different dimensions to the image
