In Tornado chart i want to make one field fixed and other one user can change

[gautampruthi]

Hi There i am visualizing two organizaton performance in different categories using tornado chart and i want one organization to be fixed and other one user can change. how to do that.

For example i want in below visual University A university to be default and other one user can change.

[DataVitalizer]

Hi @gautampruthi 

Can you provide a mockup or a sample or the table used in that visual, that would help suggesting a solution.

Did it work ? AND(👌 Mark it as a solution to help spreading knowledge,  👉 A kudos would be appreciated)

[gautampruthi]

Hi @DataVitalizer Here you go https://drive.google.com/file/d/1VM4H6atjfjfPx6WchcIRHW4HlWPXxuHC/view?usp=drive_link 

[DataVitalizer]

The link requires authentication 

[gautampruthi]

my bad, try this one 
https://drive.google.com/file/d/1VM4H6atjfjfPx6WchcIRHW4HlWPXxuHC/view?usp=sharing

[DataVitalizer]

Which column contains organization otherwise the value 'newman university'?

For the Provider Name I found only Test Provider and Other Provider which are not part of the visual above.

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

[gautampruthi]

This is a sample data with provider name as university name
https://docs.google.com/spreadsheets/d/1uJoWsgy26a64YEP-KH1RXzMHRcSHElg-/edit?usp=sharing&ouid=11213... 

[DataVitalizer]

Here is the result I can suggest for the moment

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

[gautampruthi]

Thats what i was thinking of creating two bar charts, one will use page level filter and other will visual level filter and i will keep visual level filter set to Newman. so how did you get that.
Any steps ?

[DataVitalizer]

1. Create tow measures 

Newman Universtities= CALCULATE(COUNT(Table1[POSITIVITY_MEASURE]),FILTER(ALL(Table1[PROVIDER_NAME]),Table1[PROVIDER_NAME]="Arden University"))

Other Universtities=CALCULATE(COUNT(Table1[POSITIVITY_MEASURE]),FILTER(ALL(Table1[PROVIDER_NAME]),Table1[PROVIDER_NAME]="Arden University"))

2. Use the 'Provider Name' column as a slicer with Newman value hidden
3. Drag CAH_Name, Newman Universtities and Other Universtities into a table visual

4. Apply conditional formatting 'Bar' type on both columns (Measures)

Did it work ? AND(👌 Mark it as a solution to help spreading knowledge, A kudos 👍 would be appreciated)

[gautampruthi]

Hi,

Thanks for the help. I have two questions, first both of the measure have same code and how to hide newman value in slicer

[DataVitalizer · Accepted solution]

The first measure will return the expression you want for only Neaman University ignoring all other providers.

You can exclude the value Newman in the slicer from the Filter tab

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

[DataVitalizer]

I'm glad I was able to help @gautampruthi 👍

Was this exchange helpful? A kudos 👍 would be appreciated