5 Replies Latest reply on Jan 31, 2019 5:20 AM by Zhouyi Zhang

Filter Null values and Measure names

Karthik Suresh Jan 31, 2019 3:48 AM

Hello Everyone!

Just want to know this is possible with tableau. I am creating a chart with 3 measures and some of them have NULL . Below is the example of my Data

Month	Sales area1	sales area2	sales area 3
Jan2018	100	200	300
Feb2018		250	260
March2018	300		200

So i want to have my bar graph showing in

Jan2018 all the three measure names and values in side by side bar graph

Feb2018 only sales area 2 and sales area 3

March 2018 only sales area 1 and sales area 3

I want to filter out the Measure names aswell .

Thanks in advance

Regards

Karthik Suresh

1. Re: Filter Null values and Measure names

Zhouyi Zhang Jan 31, 2019 4:05 AM (in response to Karthik Suresh)
Hi, Karthik

Please find my solution attached.
Below is steps:

1st, pivot your data

2nd, build the view as below

Hope this helps

ZZ

Book1_v10.2.twbx 15.4 KB
Like Show 0 Likes(0)

Actions
2. Re: Filter Null values and Measure names

Karthik Suresh Jan 31, 2019 4:57 AM (in response to Zhouyi Zhang)

Hi Zhouyi,

I am trying to use your solution, When i create a pivot with these values i have a column which says Pivot values and Pivot names , Which one should I use to create the view, the measure values or the pivot values?

Regards
Karthik Suresh
Like Show 0 Likes(0)

Actions
3. Re: Filter Null values and Measure names

Zhouyi Zhang Jan 31, 2019 5:09 AM (in response to Karthik Suresh)

Hi, Karthik

my bad. I did a rename of pivot names to MeasureName and pivot value to MeasureValue shown in my view.

so just use the "Pivot Name" to replace the 'MeasureName' and 'Pivot Value' to replace the 'MeasureValue' in my sample.

Please let me know if you have further quesiton.

ZZ
Like Show 0 Likes(0)

Actions
4. Re: Filter Null values and Measure names

Karthik Suresh Jan 31, 2019 5:19 AM (in response to Zhouyi Zhang)

Hi Zhouyi,

Works perfectly!!! Thanks!!!!!

Regards
Karthik Suresh
Like Show 0 Likes(0)

Actions
5. Re: Filter Null values and Measure names

Zhouyi Zhang Jan 31, 2019 5:20 AM (in response to Karthik Suresh)

you are welcome

ZZ
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Filter Null values and Measure names

1. Re: Filter Null values and Measure names

2. Re: Filter Null values and Measure names

3. Re: Filter Null values and Measure names

4. Re: Filter Null values and Measure names

5. Re: Filter Null values and Measure names

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account