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 III
Super User III

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 III
Super User III

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
Highlighted
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 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors