Azure Data Factory Data Movement Activities 03-25-2017 10:07 AM

[cwebb22]

Visual Representation of Data Movement Activities in Data Factory Service

eyJrIjoiNDk0YTU1ZWMtMGZjNS00MDJjLTg1NmQtMTI4MWU0MmJiMWJjIiwidCI6ImI2MjA5MmViLTUzYzAtNGYyNy04YTM2LTNkNGY3NjYyNzg3OSIsImMiOjN9

[Anonymous]

Nice!
What is this matrix with KPIs on the right?

[cwebb22]

I'm using the Matrix Preview + Import and Display KPI Preview feature to generate the matrix visualization. 

[Anonymous]

@cwebb22 Thank you

What is "Import and Display KPI Preview feature ..."

How do you put the "green/red/yellow" KPI's into matrix?

I miss something

Thanks

Michael

[cwebb22]

Hi Michael,

I'm specifically referencing this: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-import-and-display-kpis/

High level steps are:

1. Connect and shape data using PowerQuery
2. Load data to PowerPivot Model
3. Create Explicit measure in PowerPivot
4. Create KPI from measure
5. Save and Close File
6. Open Power BI Desktop
7. Navigate to File>Import>Excel Workbook Contents
8. Import PowerPivot Model and Contents using Dialog
9. View Hierarchy in Field List
10. Visualize using Matrix Preview

Hope this helps - accept as solution if it works for you!

Charles

[Anonymous]

Oh, I see. You are using the "KPI's from measure" feature...!

I've forgotten it even still exists!

(Since the topic is not a question - it doesn't allow me to mark a solution, but I gave you thumbs up :))

Thanks a lot!

Michael