You Inspire me to take a leap of faith and plunge confidently into the unknown.... Building My project dashboard and feeling happy that i could get these similar measures working for me aswell. I'll take this to the next level.
Great video. I learnt a lot from it. 1 silly question though. How did you get the 3 bars at the top of any card or chart you selected? Its has this extra spacing at the top for each box selection you made. I find that really useful to help select a card/chart especially for tables without accidentally clicking on a column and sorting it. Appreciate your sharing for this.
Really enjoyed this video. Would setting up a theme file be practical for a report of this type? It seems as if you're changing many of the formats, especially of the cards, in a consistent manner.
Hi Ken, potentially! It boils down to how "templatizable" you'd make this scorecard for other reports. But theme files are fantastic for saving a lot of formatting effort, for sure.
Great video and series ! In your website you present the KPI Scorecard Report differently through a matrix.. How do you manage to show different metric details (for e.g. columns Rank, Total Value, etc.) per each row ? Using UNION fx or a grouping fx ?
Good question! I used a DAX generated table to create a column for each metric, then used a measure to identify the filter context for the matrix table and return one of X values depending on which category row it was on.
@@HavensConsulting I am a newbie in Power BI. I am trying to do something similar but I don't quite how you did this. Do you have another video that explain how you create a measure to identify the filter context for the matrix table? Much appreciated.
What would be the reason I would not get "1" on a rank when NO store (slicer) activated/picked? I have 3 KPIs, my Sales is a 1 of 391, the other are 190 of 391, & and 186 of 391 even when no slicers or filters are running ... Any help would be great :|
Awesome video! Very clean and conveys a lot of information. I will be coming back to this and your future parts when I need to build out a scorecard
You Inspire me to take a leap of faith and plunge confidently into the unknown....
Building My project dashboard and feeling happy that i could get these similar measures working for me aswell. I'll take this to the next level.
Glad to hear it! Thanks for watching :)
SIMPLY OUTSTANDING! Very advanced level creative video.
Nice job. Very good walkthrough. Looking forward to other parts.
Great video. I learnt a lot from it. 1 silly question though. How did you get the 3 bars at the top of any card or chart you selected? Its has this extra spacing at the top for each box selection you made. I find that really useful to help select a card/chart especially for tables without accidentally clicking on a column and sorting it.
Appreciate your sharing for this.
Loving your formatting taste.
Thanks!
A very clear informative ,use full video. Thankyou for creating this from scratch . This way uts v much helpfull.
Great Job! Thank You!!
Really enjoyed this video. Would setting up a theme file be practical for a report of this type? It seems as if you're changing many of the formats, especially of the cards, in a consistent manner.
Hi Ken, potentially! It boils down to how "templatizable" you'd make this scorecard for other reports. But theme files are fantastic for saving a lot of formatting effort, for sure.
Thanks a lot. How can I get this dataset?
I like your videos, thank you and go on.
Great!
could you explain how you have created the "DAX Measures" Table ? thanks
Fixing Measure Madness - powerbi.tips/2016/10/fixing-measure-madness/
sorry for the stupid question
ua-cam.com/video/-epmSfp4QKI/v-deo.html I also have a similar video. Where I show both how to create this in Excel OR Power BI :)
Great video and series !
In your website you present the KPI Scorecard Report differently through a matrix.. How do you manage to show different metric details (for e.g. columns Rank, Total Value, etc.) per each row ? Using UNION fx or a grouping fx ?
Good question! I used a DAX generated table to create a column for each metric, then used a measure to identify the filter context for the matrix table and return one of X values depending on which category row it was on.
@@HavensConsulting Thanks for the tip ! ;)
@@HavensConsulting I am a newbie in Power BI. I am trying to do something similar but I don't quite how you did this. Do you have another video that explain how you create a measure to identify the filter context for the matrix table? Much appreciated.
@@sirknightzjr2 I don’t have any other videos on this at the moment but I’ve made a note to record something about this in the future!
The color range I have in my power BI is different. How do you change it?
Hi there, I’m using a custom color theme. You can change that from the theme button on the home ribbon at the top
What would be the reason I would not get "1" on a rank when NO store (slicer) activated/picked? I have 3 KPIs, my Sales is a 1 of 391, the other are 190 of 391, & and 186 of 391 even when no slicers or filters are running ... Any help would be great :|
Hi Brandon, I'm honestly not sure without spending time looking at the measure and the model you're working with