Creating a new table based on another, using a criteria set in a third table

[Anonymous]

Hello,

I have several tables, the two main ones are Audits and Findings. Both Tables detail Business Sections. The Business Section in the audit table has either a single business section assigned, or sometimes may have multiple business sections assigned (eg "Finance" or "Finance, Safety, Personnel").

I have a slicer that uses a filter based on a code (set in a measure) that looks to find a particular text (eg. Finance) and return true or false. The Slicer works great when I'm viewing a Table Visual, but doesn't work if I'm using a graph.

I was thinking or creating a new table based on the Audit table that has multiple entires for each audit for each business unit. For example, if there was a line entry for an audit that was targetting Finance, Safety, and Personnel, the new table would contain three rows, one for each Business Section. Most fields would be identical except for the Business Section (eg the first row would show Finance, the second would show Safety and so on...) I need the Table show all audits in the shedule.

Any ideas or suggestions to point my in the rigtht direction. This is slightly beyond my ability but I think it's possible. I have created a small table that has all of the Business Sections.

Any suggestions?

Cheers

Leon

[Ashish_Mathur · Accepted solution]

Hi,

You will have to do this in the Query Editor.  Right click on that column and select Split data > By delimiter.  Specify the delimiter and under Advanced Options, select Rows.

Hope this helps.

[Anonymous]

Many thanks Ashish,

That is a much easier and elegant solution than what I was attempting. It's been a steep learning curve, I'm on week two of using Power BI :-).

Cheers,

Leon

[Ashish_Mathur]

You are welcome.