6 Replies Latest reply on Apr 25, 2018 5:18 AM by Muhammad Kamal

# How to create this visual

Dear All,

If I have the data shown in the following table, how can I create the visual in the screenshot, thanks in advance

 AREA YEAR MEASURE1 A1 2017 65 A2 2017 28 A3 2017 18 A4 2017 18 A5 2017 27 A6 2017 24 A7 2017 13 A8 2017 15 A1 2018 77 A2 2018 68 A3 2018 41 A4 2018 35 A5 2018 32 A6 2018 26 A7 2018 24 A8 2018 18

• ###### 1. Re: How to create this visual

In order to get the viz you need, data needs to be modified. Please check the below image:

I've modified the data as below:

 AREA AREA2 YEAR1 YEAR2 MEASURE1 MEASURE2 A1 A1 2017 2018 65 77 A2 A2 2017 2018 28 68 A3 A3 2017 2018 18 41 A4 A4 2017 2018 18 35 A5 A5 2017 2018 27 32 A6 A6 2017 2018 24 26 A7 A7 2017 2018 13 24 A8 A8 2017 2018 15 18

Regards,

Sudheer

3 of 3 people found this helpful
• ###### 2. Re: How to create this visual

Solution attached. Version 10.3

2 of 2 people found this helpful
• ###### 3. Re: How to create this visual

No need to modify data if  we  do data blending and  use data source filter. I have attached solution

• ###### 4. Re: How to create this visual

Thanks all for the support, I'll test and feed you back with the updates,

• ###### 5. Re: How to create this visual

Hi @sudheer.kumar.5,

how you manage to invert the direction of the axis without transforming the numbers to negative ?? can you attach the twbx file ?? thanks in advance

• ###### 6. Re: How to create this visual

Hi All,

I appreciate all of your replies, gave me a lot of thoughts, which guided me to do it without Duplication or Blinding, and here's how:

1- Create Calculated Field X, if YEAR is 2017 then X= -1* MEASURE1, else if YEAR is 2018 then X = MEASURE1, else X=0

2- Drag AREA to Rows, SUM(X) to Columns, YEAR to Color

3- Modify the format of Negative numbers to appear as Positive

please check the screenshot of the result "please note the numbers are different than the sample presented in the first post, this is from Live workbook"

1 of 1 people found this helpful