Help to structure visuals and proceed to next record

[Anonymous]

We would like to create a list/report that retrieves data in the manner noted below, column 1 lists a facility and services provided, column 2 notes the charges and saving for the column on the left, then we'd like succeeding records to be presented in the same manner.

I'm fairly new to Power BI and I'm looking for some early guidance and recommendation about which visuals to use.

Facility name #1 brief description - High $ services  --Service #1 --Service #2  --Service #3  --Service #4	Billed charges $10,000 Allowed charges $2,500 savings  $7,500 savings 75%
Facility name #2 brief description - High $ services  --Service #1 --Service #2  --Service #3  --Service #4	Billed charges $10,000 Allowed charges $2,500 savings  $7,500 savings 75%
Facility name #3 brief description - High $ services  --Service #1 --Service #2  --Service #3  --Service #4	Billed charges $10,000 Allowed charges $2,500 savings  $7,500 savings 75%

the table above intends to show 3 rows and 2 columns.

[Anonymous]

Here is a better image, I'd like to have the data on the right coupled with the data on the left

[v-lili6-msft]

hi @Anonymous 

You may try matrix visual to get it.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

If not your case, please share your sample data and your expected output, that will be a great help.

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Lin

[Anonymous]

Good morning and thanks for your reply, do I have a way to upload an image?

[parry2k]

@Anonymous look at matrix visual, you need to put Facility and Service columns on row and charges description column on columns value on the values. 

And on rows, drill down to next level and you will get what you are looking for.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

thanks for your quick reply, here is a better image.