Adding Multiple Rows Based on Filter

[Anonymous]

Hi. Let me first say that I am new to the Power BI application so I apologize in advance if I'm asking elementary questions.

I'd like to add multiple rows based on unique filter parameters into one table. In my attached file, I'd like to add the 'I-55' row to the first table with 'I-44'. Is it possible to add a second 'Values' entry and configure in the same manner as the first 'Values'.

Thanks.

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Anonymous]

Absolutely. I currently have created 2 tables that contain the same fields. This is great in that I can update the source data on a monthly basis and the results in the table will update automatically. I've filtered field in the 1st column. Is it possible to have 1 table and be able to include multiple rows with the filtered Field?

I-44 (filtered)	Average of Lane Blockage Duration	Average of Queue Clear Duration
I-55 (filtered)	Average of Lane Blockage Duration	Average of Queue Clear Duration
XX (filtered)	Average of Lane Blockage Duration	Average of Queue Clear Duration

Thanks for your help. Like I said, I'm new to Power BI so I may not fully understand the intended use of the program.

[natabird3]

If its just the two values you want to display in the same table you can probably use the concatinate () function in a dax measure to create the desired outcome, if its two measures and you would like to put in the same column on a different row you can try with the matrix if it works, but as a table its not possible using the Power Bi dekstop program, if you use something like Visual Studio and code it in there you can define where to dispaly exactly the data in each column/row. Alternatively, you can try to use the paginated report builder which could potentially solve this issue.