Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I'm using a Treemap visual to represent a client's test execution status across multiple functional areas. I'm using a drill down for the map, in the order of Functional Area > Responsible Tester > Test Exec Status.
When I drill down to Test Exec Status I can change the data colours for each one (Passed/Failed/No Run/Blocked/NA/Not Complete), but when I drill back up and then down again into a different Responsible Tester, the colours have not been applied to the various statuses.
So my overall question is whether there's a way to apply colours to ALL of my Test Exec Status values in one go? Otherwise it's looking like I'll have to apply the colours 50+ times over, considering the number of functional areas and testers there are
Many thanks!
Ran into a similar problem. I have a number of Status which is used in different PIE charts. I would like to be able to specify the color per status. So e.g. OPEN=BLUE and DONE=GREEN and IN PROGRESS=YELLOW
The problem is that in some PIE charts I have only OPEN and IN PROGRESS. What happens is that it reads the colors from the JSON file in the order they are listed. So in some cases it shows OPEN=BLUE and IN PROGRESS=GREEN instead of YELLOW.
One solution could be that in the JSON file its possible to specify which color goes with which value (status) OR another solution could be to specify several colors for different Charts. So e.g. have PIE1= xyz colors and PIE2 = 123 colors. When under the Data Color option i would select the one i want to use for the specific PIE chart.
Please check if the Report Themes feature meets your requirement, using this feature, you can apply a color theme to your entire report.
Regards,
Lydia Zhang
Hi Lydia,
That does look pretty useful, thanks! Another quick question about it, would I be able to determine the data points that each colour is applied to from the .json file? So it might look something like this:
{ "name": "Example", "dataColors": [Failed = "#568410", No Run = "#3A6108", Not Completed = "#70A322"] "background":"#FFFFFF", "foreground": "#3A6108", "tableAccent": "#568410" }
Or is there another way to ensure the colour codes are assigned to the desired data points?
Thanks,
Sam
@Locken,
We are not able to ensure the color codes are assigned to desired data points with the .json file.
Regards,
I think I have the same/similar issue. I have a pie chart which at the top level is contract renewed (green) and contrac ended (red). The next layer is the product, so when I drill down on contract renewed for example I want them to all display green not in various colours - is this possible and if so how?
Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |