cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Locken Frequent Visitor
Frequent Visitor

Data colours across same drill down views

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 Smiley Frustrated

 

Many thanks!

5 REPLIES 5
Moderator v-yuezhe-msft
Moderator

Re: Data colours across same drill down views

@Locken,

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Locken Frequent Visitor
Frequent Visitor

Re: Data colours across same drill down views

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

Moderator v-yuezhe-msft
Moderator

Re: Data colours across same drill down views

@Locken,

We are not able to ensure the color codes are assigned to desired data points with the .json file. 

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hoodeamy Frequent Visitor
Frequent Visitor

Re: Data colours across same drill down views

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. 

UlrickT Frequent Visitor
Frequent Visitor

Re: Data colours across same drill down views

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.

 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 209 members 1,703 guests
Please welcome our newest community members: