Solved
Azure Data Factory Data Movement Activities
Visual Representation of Data Movement Activities in Data Factory Service
eyJrIjoiNDk0YTU1ZWMtMGZjNS00MDJjLTg1NmQtMTI4MWU0MmJiMWJjIiwidCI6ImI2MjA5MmViLTUzYzAtNGYyNy04YTM2LTNkNGY3NjYyNzg3OSIsImMiOjN...
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
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