๐๐จ๐ฐ๐๐ซ ๐๐ ๐๐ฒ๐ง๐๐ฆ๐ข๐ ๐๐จ๐ฅ๐จ๐ซ ๐๐ก๐๐ง๐ ๐ ๐ข๐ง ๐๐ข๐ฌ๐ฎ๐๐ฅ๐ฌ ๐๐ก๐๐ซ๐ญ ๐๐๐ฌ๐๐ ๐จ๐ง ๐๐ฅ๐ข๐๐๐ซ ๐๐๐ฅ๐๐๐ญ๐ข๐จ๐ง
This is a known tip to many, but beginners of Power BI , this must be a useful tip.
Step 1 - Create a Clustered Column Chart
Step 2 - Create a Slider using What If parameter using Rank Numbers
Step 3 - Change the ending value using COUNTROWS() Function
Step 4 - Create Conditional formatting Rule and apply the rule to Visual
Step 5 - Create Dynamic Title
Functions or Commands Covered :
- WhatIf Parameter Command
- GENERATESERIES() Function,
- SELECTEDVALUE() Function,
- COUNTROWS() Function;
- Simple IF() Function
- Conditional Formatting (Field Value)
- Dynamic Title
For complete Tutorial - Click on below Link
For more Power BI, Excel, PowerPoint, SQL, AZURE Tips keep watching this space.
#powerbi #powerbidesktop #powerbitrainer #powerbifreelancer #powerbisupport #powerbiadvanced #conditionalformatting
#perepaedu #vijayperepa