cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alex_0201
Post Partisan
Post Partisan

Visual details expansion

Hi, struggling to understand which way to go here. 

I have a pie chart here that shows distribution of NPT value by Equipment failure type

 

0.PNG

I would like to show what all these abbrevaiations mean (EN, N, E). So I thought I would create a colunm/measure and add it into the Details field of the pie chart. So the explanation would appear in the black box when I hover the mouse over the pic chart.

 

3.PNGSo I guess I would need to create an extra column that assigns to each of N, EN, E values in the current column respective values of Npt, Equipment Npt, Equipment. What would be the formula?

And should I create a custom column in Query or should I go for a measure/column in the report view?

Capture.PNG

Thanks in advance!

1 ACCEPTED SOLUTION
tex628
Community Champion
Community Champion

A report column like this should do the trick, 

 

Column = SWITCH(
[equip_fail_type], 
"N" , "Npt" ,
"EN" , "Equipment Npt" ,
"E" , "Equipment"
)

 

 


Connect on LinkedIn

View solution in original post

2 REPLIES 2
tex628
Community Champion
Community Champion

A report column like this should do the trick, 

 

Column = SWITCH(
[equip_fail_type], 
"N" , "Npt" ,
"EN" , "Equipment Npt" ,
"E" , "Equipment"
)

 

 


Connect on LinkedIn

@tex628 Many thanks 😊

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.