Let's say I have this structure in Visio.
I also have this data in Excel:
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.
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.
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.
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)?
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.