Need some guidance on creating visualisation

[bhanu7693]

Hello All,

My name is Bhanu Prakash, I am very new to Power BI. I enclosed the graphs which I made it in the excel sheet. Now, I want to make this graphs in power bi. Can any one help me on this?

First chart is a clustered column chart, for this chart I used excel offset function for calculating runs and wickets. for example, each over consists of 6 balls, for every 6 balls it will sum up the score of 6 balls, and count the number wickets in that particular over. Is there any offset function in Power BI to caluculate the columns or tables? 

Second chart is a line chart, for this chart I made the line graph by using calculated aggregated score column in power bi, but I need present the wickets on the line graph, Is there any option yo represent the wickets on the line graph?

Thanks in advance

Bhanu Prakash  

 

[amitchandak]

@bhanu7693 ,

For wicket create a measure like this for the first one and create a clustered like visual without a secondary axis. With line color as #FFFFFF00 and marker is enabled

Wicket new measure = if(not(isblank([wickets])), [Run], blank() )

But you will not be able to show two-wicket by this logic

Check if some custom visual can help

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals