Forum Discussion
graphic 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.
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.
Roeder , great alternative . I liked very good implemented method , enjoyed the tes2 , option 2 . But I think the middle of concern in a BI tool terms to use artificial methods to achieve a result , it is the basic of a BI tool. I think it's not such complexity deploy it. If not so advanced and pressed for deliveries of dashboards , I would resign this platform. I think she has a lot to grow, but to grow giving priority to basic concepts like this that I exposed . Roeder , thank you ..
ur welcome mr walnei... indeed there's still a lot of promise for this platform, and I would rather stick and grow in knowledge with it for a while as well. Other than qlik-sense, there's just no other online BI facility that covers as much feature-sets and as practically accessible to me for now (regardless of its frustrating if not challenging limitations).
