𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐃𝐲𝐧𝐚𝐦𝐢𝐜 𝐂𝐨𝐥𝐨𝐫 𝐂𝐡𝐚𝐧𝐠𝐞 𝐢𝐧 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 𝐰𝐢𝐭𝐡 𝐬𝐥𝐢𝐜𝐞𝐫
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 - SUBSCRIBE For more Power BI, Excel, PowerPoint, SQL, AZURE Tips keep watching this space. #powerbi#powerbidesktop#powerbitrainer#powerbifreelancer#powerbisupport#powerbiadvanced#conditionalformatting#perepaedu#vijayperepa