Hi, I am wanting to replicate a report in Power BI. I have some "Conversion Data" that's based on some metrics from our server: This is how the fact table looks (with the individual metrics in the "Metric" column: I already know that creating a separate pivot is ideal; but I can not get the format i am wanting - this is my result: What are tips get the view I want ?? Thanks!

Hi Anonymous, Not really sure of what is your main goal in this question. Do you want to return the CONVERSION DATA part to your PBIX file? If so you need to create measure for each of the Conversion metrics based on the LEAD/UNIT DATA. Can you explain a little bit better and give examples of the calculations and expected results.Regards,MFelix

If I create a measure for each "conversion data" peice, I can not get it to be positioned as a 'row header'. I want to pivot the conversions to align with the column headers for the Lead/Unit Data. Below, I added text to show where I want the CVR measures positioned; I am unable to correctly provide the values.

Hi Anonymous, You need to use the measures and the use the solution on this blog to make the measure as row in a matrix. Check the PBIX file attach for an example just replace the measures on the file by the ones you need. Regards,MFelix

Hi, thanks for your reply. It seems that this does not completely work for what I am needing. Once I create the measures and make the switch matrix, the values that populate are incorrect: Your fact table in the example file does not look like my fact table; this may be the problem here.

Hi Anonymous, From the tests I made with different measures and table formats, I never got incorrect results with this approach. Can you please share a copy of your PBIX file and expected results? If you need you can share it through private message so you don't publish sensitive data or send a mockup file. Regards,Mfelix

Creating Conversions in a matrix | Microsoft Fabric Community

11 Replies

MFelix
Super User
8 years ago
Hi Anonymous,

Not really sure of what is your main goal in this question.

Do you want to return the CONVERSION DATA part to your PBIX file? If so you need to create measure for each of the Conversion metrics based on the LEAD/UNIT DATA.

Can you explain a little bit better and give examples of the calculations and expected results.
Regards,
MFelix
- Anonymous
  Not applicable
  8 years ago
  If I create a measure for each "conversion data" peice, I can not get it to be positioned as a 'row header'.
  
  I want to pivot the conversions to align with the column headers for the Lead/Unit Data. Below, I added text to show where I want the CVR measures positioned; I am unable to correctly provide the values.
  - MFelix
    Super User
    8 years ago
    Hi Anonymous,
    
    You need to use the measures and the use the solution on this blog to make the measure as row in a matrix.
    
    Check the PBIX file attach for an example just replace the measures on the file by the ones you need.
    
    Regards,
    MFelix
    Matrix_Columns_Rows.pbix61 KB

Forum Discussion

Creating Conversions in a matrix

11 Replies

Related content

FX Conversion Logic

Conversion

Matrix table

Bit values conversion

Creating matrix