Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
How is the following type of chart acheived? Also, can it be made to stand on end ie. rotated 90 degrees to an upright position?
MAny thanks.
Solved! Go to Solution.
Click on the Chart, go to Format your Visual in the Visualizations pane. Search for "Columns" attribute and then click on "fx" to apply conditional formatting in your Chart.
There on, use the following rules,
You need to select "Rules" as your Format Style, and in the the field column, select the "Measure" or the Aggregate Column value (in my case, it is Sum of Revenue) that you are using on your Y-Axis.
Now, create the rules as you would like to see the colors (I copied the colors from your chart and made the rule accordingly. You may copy the rules as I applied above to get the desired result)
As for rotating it 90 degrees, do you mean to say changing the Chart's direction to horizontal bars? You can easily do it by changing the chart type to Stacked Bar Chart. Click on this chart as depicted in the image below,
You will get a result similar to this,
Thank you. Very much sppreciate your response.
Click on the Chart, go to Format your Visual in the Visualizations pane. Search for "Columns" attribute and then click on "fx" to apply conditional formatting in your Chart.
There on, use the following rules,
You need to select "Rules" as your Format Style, and in the the field column, select the "Measure" or the Aggregate Column value (in my case, it is Sum of Revenue) that you are using on your Y-Axis.
Now, create the rules as you would like to see the colors (I copied the colors from your chart and made the rule accordingly. You may copy the rules as I applied above to get the desired result)
As for rotating it 90 degrees, do you mean to say changing the Chart's direction to horizontal bars? You can easily do it by changing the chart type to Stacked Bar Chart. Click on this chart as depicted in the image below,
You will get a result similar to this,
Hi ,
Is there a way to compare with dynamic value ?
For example I want to compare the average sales vs total average sales
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |