cwebb22
9 years agoAdvocate II
Azure Data Factory Data Movement Activities
Visual Representation of Data Movement Activities in Data Factory Service
eyJrIjoiNDk0YTU1ZWMtMGZjNS00MDJjLTg1NmQtMTI4MWU0MmJiMWJjIiwidCI6ImI2MjA5MmViLTUzYzAtNGYyNy04YTM2LTNkNGY3NjYyNzg3OSIsImMiOjN9
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
5 Replies
- AnonymousNot applicableNice!
What is this matrix with KPIs on the right?- cwebb22Advocate II
I'm using the Matrix Preview + Import and Display KPI Preview feature to generate the matrix visualization.
- AnonymousNot applicable
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