cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Visio visual - two levels of hierarchy

Let's say I have this structure in Visio.

Przechwytywanie.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I also have this data in Excel:

Przechwytywanie2.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Is it possible to make a "two-level slicer" so that I could filter data on i.e. A or a1?

What I mean is... is it possible to use two "ID" columns instead of one.

10 REPLIES 10
Highlighted
Super User IV
Super User IV

Re: Visio visual - two levels of hierarchy

Hey,

 

there is just a simple answer: Unfortunately not!

 

Regards



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Highlighted
Helper III
Helper III

Re: Visio visual - two levels of hierarchy

I was hoping for a more optimistic answer 😉

Highlighted
Super User IV
Super User IV

Re: Visio visual - two levels of hierarchy

Hope will never die 😉



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Highlighted
Resolver III
Resolver III

Re: Visio visual - two levels of hierarchy

You can Import from the store... I am not sure it is related to your question but have a look at it...

 

Capture.PNG

 

Capture.PNG

Highlighted
Helper III
Helper III

Re: Visio visual - two levels of hierarchy

I know that one.
I wanted to use a "nice" graphic.
Highlighted
Frequent Visitor

Re: Visio visual - two levels of hierarchy

You can achieve your scenario even with one ID column. You will have to model your data like this:

 

 

LevelData
Aasds
Afs
A1asds
A2fs
Helper III
Helper III

Re: Visio visual - two levels of hierarchy

Well, I think it won't work in my situation.

I have an organisation structure and, apart from columns for Divisions and Departments, there is a column for employees.

If I choose a person he or she will have duplicated figures.

 

Przechwytywanie3.PNG

 

Przechwytywanie4.PNG

 

EDIT: Well, ok, I can divide it by two 🙂 Let's try! 🙂

 

EDIT2: No, it doesn't work. When I see all the company I have to divide salaries by two, but when I choose a particular Department I should not divide. It would be quite difficult to create a proper measure in such case.

Highlighted
Frequent Visitor

Re: Visio visual - two levels of hierarchy

What if you split the table into two. One having department information that is bound to Visio visual and one having person information (with a foreign key to department table)?

Highlighted
Helper III
Helper III

Re: Visio visual - two levels of hierarchy

So the "visio table" should have one column, right?

Przechwytywanie5.PNG

 

And how should I connect it to my "person table" which has two columns?

Przechwytywanie3.PNG

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors