8 Replies Latest reply on Feb 14, 2019 12:10 PM by Ken Flerlage

Measure values shelf grayed out with measures in view

John Lu Sep 11, 2018 11:14 AM

I am using tableau desktop 2018.2 and I have some insurance data from excel with 2 dimensions and the rest are measures but when I imported data from excel and I drag my measures into the view, 1) I get no title and 2) it doesn't activate the measure values shelf so it is treating it as a text

Not sure why that is happening and how to fix it. All measures are just counts summarized by master code.

I have attached a test workbook. If I drag the whole Measure Values, it will show but when I drag individual measure, it won't show not sure why

1. Re: Measure values shelf grayed out with measures in view

Ken Flerlage Sep 11, 2018 9:09 AM (in response to John Lu)

Any chance you could share a packaged workbook?
Like Show 0 Likes(0)

Actions
2. Re: Measure values shelf grayed out with measures in view

Deepak Rai Sep 11, 2018 9:09 AM (in response to John Lu)

Hi John
We need a workbook to help you.
Thanks
Deepak
Like Show 0 Likes(0)

Actions
3. Re: Measure values shelf grayed out with measures in view

John Lu Sep 11, 2018 10:27 AM (in response to Deepak Rai)

Thanks I have just added a workbook for your reference.
Like Show 0 Likes(0)

Actions
4. Re: Measure values shelf grayed out with measures in view

John Lu Sep 11, 2018 10:27 AM (in response to Ken Flerlage)

Thanks I have just added a workbook for your reference.
Like Show 0 Likes(0)

Actions
5. Re: Measure values shelf grayed out with measures in view

Ken Flerlage Sep 11, 2018 12:42 PM (in response to John Lu)
Is this what you're looking for?
If so, then first drag Measure Names to the columns shelf. Then drag Measure Values to the Text card. See attached.

test (2).twbx 16.6 KB

1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
6. Re: Measure values shelf grayed out with measures in view

John Lu Sep 11, 2018 1:39 PM (in response to Ken Flerlage)

Thank you, yes for some reasons when I dragged individual measure into view, it won't recognize it as measure but when I drag the whole thing like you did, it recognizes.
Like Show 0 Likes(0)

Actions
7. Re: Measure values shelf grayed out with measures in view

djay temp Feb 14, 2019 11:37 AM (in response to Ken Flerlage)

How are you getting aggregation columns (sum of MTD BC Close Ratio) to appear at the top along side Master and Parent Agency. For my workbook, they getting moved at the bottom.

Edit :- I am on 10.5.0 version (64 bit)
Like Show 0 Likes(0)

Actions
8. Re: Measure values shelf grayed out with measures in view

Ken Flerlage Feb 14, 2019 12:10 PM (in response to djay temp)

I'm not sure I follow what you're asking. Can you share an example?
Like Show 0 Likes(0)

Actions