Forum Discussion
How can I create this visual in Power BI?
Hi,
PBI file attached. In a clustered column chart, one cannot colour the columns conditionally so i have coloured the data labels instead.
Hope this helps.
Hi Ashish_Mathur
Here is the link Excel link with data for 6 months.
The 4% and 7.7% for Email in my example were just hard coded into a PowerPoint table to create the chart. The formula for Lead to Contact conversion = sum(Number of Leads Converted to Contacts)/sum(Number of Leads)
Thanks for your help
Excel Sample Data
Hi,
PBI file attached. In a clustered column chart, one cannot colour the columns conditionally so i have coloured the data labels instead.
Hope this helps.
Ashish_Mathur Thanks! very helpful. Do you think it's possible to somehow display the percent change from previous period to current period?
Even if you have a suggestion for a technique I can look into myself.
From the example in my original post:You are welcome. Someone else will help you with that.