Azure Data Factory Data Movement Activities
Hi Michael,
I'm specifically referencing this: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-import-and-display-kpis/
High level steps are:
- Connect and shape data using PowerQuery
- Load data to PowerPivot Model
- Create Explicit measure in PowerPivot
- Create KPI from measure
- Save and Close File
- Open Power BI Desktop
- Navigate to File>Import>Excel Workbook Contents
- Import PowerPivot Model and Contents using Dialog
- View Hierarchy in Field List
- Visualize using Matrix Preview
Hope this helps - accept as solution if it works for you!
Charles
What is this matrix with KPIs on the right?
I'm using the Matrix Preview + Import and Display KPI Preview feature to generate the matrix visualization.
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
Hi Michael,
I'm specifically referencing this: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-import-and-display-kpis/
High level steps are:
- Connect and shape data using PowerQuery
- Load data to PowerPivot Model
- Create Explicit measure in PowerPivot
- Create KPI from measure
- Save and Close File
- Open Power BI Desktop
- Navigate to File>Import>Excel Workbook Contents
- Import PowerPivot Model and Contents using Dialog
- View Hierarchy in Field List
- Visualize using Matrix Preview
Hope this helps - accept as solution if it works for you!
Charles
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