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
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)?

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
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

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 Kudoed Authors