How did I create app like report in Power bi ?
One thing that you will observe evidently when working with power bi is that your perspective and creative horizon boardens up. You start to realize which colour scheme and template seems promising form customer's point of view.
One such UI design is neumorphic template which draws from both skeumorphism and flat design by pairing a monochromatic color palette with subtle shadows that make the buttons/shapes appear tactile.
I created one such report. Check out the report using below link:
Dataset used is availaible on kaggle.
The backgroud is a JPG image which serves as a designing template and provides the app like feel to the report. The image is designed in MIcrosoft power point. The visuals are then adjusted in the shapes on background image.
Load the given image to canvas background and then adjust the visuals in the shapes.
Visuals that you can find on the report :
Dynamic Greeting : Created used DAX which takes the current time using NOW() and uses the HOUR in switch to display customised greeting w.r.t time of the day.
DAX :
WELCOME TEXT =
var hour = HOUR(NOW())
var greeting =
SWITCH(
TRUE(),
hour >= 0 && hour <5 ,"Good night !",
hour >= 5 && hour <12 ,"Good morning !",
hour >= 12 && hour <18 ,"Good afternoon!",
hour >= 18 && hour <24 ,"Good evening !"
)
return
greeting &'' "& "your name"
Date picker : Select date field in SLICER visual. Select AFTER to choose a particular date from date picker and hide the second date select option using a box .
Create measures to use in cards for all variables such as heart rate, calories, etc.
DAX :
Single day heart rate =
var _mindate = MIN([date])
return
CACULATE(avg[heart rate],TREATAS({_mindate},[date]))
Check out the videos for detailed tutotrial :
APP LIKE DESIGN : https://www.youtube.com/watch?v=cYwioeHu_OU&t=1666s
DATE PICKER : https://www.youtube.com/watch?v=zhWtU0DynCk&t=499s
Comments