Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good morning
I need to make a clustered column chart that re-calibrates the axis and the the columns when filters are selected on the dashboard. Right now, the clustered column chart shades the total column the amount represented by the filters. When the shaded amount is much less than the total, you cannot really see the values. Why cant clustered column charts just show the values for the selected filters instead of shading it as part of the total.
For example, here is picture of my dashboard with no filters selected
Note the clustered column chart in the top right
Now, here is a picture with a product selected in the dashboard
As you can see, the clustered column chart is shaded with the filtered values and it is very difficult to see the actual revenue values and the trend of these shaded values over time. How can I set the clustered column chart to just show the values for the product selected (with new y axis values) instead of showing it as a shaded percentage of the total revenue from all parts?
Solved! Go to Solution.
I just figured out the solution so Ill post it for others..
Click on Edit interactions under Visual Tools-> Format. Then click on the visual that is doing the filtering. In the top right, select filter (instead of highlight). It is the left most choice of the 3 that you are given
Now it will dynamically change the Y axis to be the correct range for whatever filter is chosen
I just figured out the solution so Ill post it for others..
Click on Edit interactions under Visual Tools-> Format. Then click on the visual that is doing the filtering. In the top right, select filter (instead of highlight). It is the left most choice of the 3 that you are given
Now it will dynamically change the Y axis to be the correct range for whatever filter is chosen
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |