cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Re: Visio visual - two levels of hierarchy

Visio table will have 2 columns (Division (primary key), some aggregate to be placed to values section). The second column is needed for filtering to work. You can represent the second column as color and delete all the color ranges if you wish.

 

Next have 2 tables (name, division (foreign key), function, salary) and (name, dept (foreign key), function, salary).

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Top Solution Authors