8 Replies Latest reply on Mar 13, 2017 7:52 AM by Pauline Le Corvec

# How to display the range for measure and highlight the dimensions

Hello Team,

My worksheet has 2 columns Segment and Profit. I created a calculated column 'Profit %' to find the % of profit.

Now my requirement #1: Display the Range of Measure

1. Please refer the column 'Profit % Range' below, that needs to be calculated based on the column  'Profit %'.

I created a new column 'Profit % Range' with the condition below, its not working for me as it shows me the below result.

if ([Profit %]>=0 and [Profit %]<30) then '0-30%'

elseif ([Profit %]>=30 and [Profit %]<40) then '30-40%'

else '>=40%'

end

Requirement#2: Highlight the dimension ONLY

How to highlight the dimension 'Segment'  as below. Please note that I dont want to highlight any other columns 'Profit % Range' and 'Profit%'. I just want to highlight dimension ONLY.

Thanks,

Srikar

 Segment Profit % Range Profit % Consumer >=40 47% Corporate 30-40 32% Home Office 0-30 21%
• ###### 1. Re: How to display the range for measure and highlight the dimensions

Hi Srikar,

Find my approach as reference below stored in attached workbook version 10.1 locate in the original thread.

Regards,

Norbert

1 of 1 people found this helpful
• ###### 2. Re: How to display the range for measure and highlight the dimensions

Hi Srikar,

Thanks for providing a workbook. As far as I am aware, it is not possible to achieve this in Tableau right now.

Adding a couple of links below, in case you have not seen them yet.

Best,

Pauline

1 of 1 people found this helpful
• ###### 3. Re: How to display the range for measure and highlight the dimensions

Oh nice! Norbert Maijoor, just to confirm, were you using the steps similar to the below KB article?

• ###### 4. Re: How to display the range for measure and highlight the dimensions

Dear Nobert,

Thanks for the solution, it's very helpful to me.

Thanks,

Srikar

• ###### 5. Re: How to display the range for measure and highlight the dimensions

Hi Pauline,

I always refer to the following vid and I am quite sure it is also possible to format the background as depicted by Srikar N

"From the top of my head" I was even lately involved in a thread where this was solved but can't recall it anymore on request.

I would like to ask my collegae ambassador Shinichiro Murakami Hi Shini, could you step in here?

• ###### 6. Re: How to display the range for measure and highlight the dimensions

Using Norbert's file.

Instead of "0" put "1" on axis.

I created A (1) as new calculated field and put it on axis of the first(let end) column as "MIN".

then fix he axis to 0 to 1.

Change the graph type to "Bar".

Then expand the size until it fit to the row width.

Thanks,

Shin

2 of 2 people found this helpful
• ###### 7. Re: How to display the range for measure and highlight the dimensions

Oke that was the "trick";) Thanks for prompt action:)

• ###### 8. Re: How to display the range for measure and highlight the dimensions

Thank you both This is very helpful!

I've referred this Community thread at the bottom of the following Knowledge Base article: Conditionally Formatting Cell Background Color | Tableau Software - my colleagues and I will work on adding a new video and updated steps in all languages.

Thanks again!