Tableau to Power BI

[sailochanar]

HI Mates :

Can u explain this type visual to design in Power BI :

this is a tableau visual

PBI Visual wht I acheieved :

here I want to know how to set color for grand total ,even any suggestions are appreciated .

And how to create this type of bullet charts in PBI : 

and can this pattern of slicer can be designed in PBI :

Tableau :

in PBI : 

Please provide your approaches to design thse sort of reports in PBI .

Thanks in Advance .

[Ritaf1983]

Hi @sailochanar 
According to the total, there is no option to get the bar as a part of the table you can try to use a bar chart with one bar and try to group that with the table.
Don't recommend using it from an effective data visualization point of view because 

since the total bar is much larger than its parts, and the purpose of the bars is to compare sizes, it simply distorts the perception and the ability to see data ratios.
Or as in the attached image of yours, the total is smaller than the first part, which makes no sense.
According to the bullet chart, we don't have this option with the conditional formatting of tables but , if you need it just for one column you can create something like that:
https://www.youtube.com/watch?v=FvxHtzG5nwk
if the need are to push it into a table, then you can use a Deneb method :
https://www.youtube.com/watch?v=Blrn53FyJ3o

according to the slicer if the goal is "one row", just resize it :

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[amitchandak]

@sailochanar ,

In Power BI

1) Use data bar under Cell elements

Grand total color use conditional formatting - Again under cell element, bar, column etc

Bullet chart - USe custom visual , option is under visual region-> three dots -> get more visual

3) You are using correct date slicer, there only small play around you can do, increase width

Tableau Vs Power BI:
https://www.youtube.com/watch?v=tAmg00Wf_cw&list=PLPaNVDMhUXGYzjFASXjdY7GNoFxvlkR54

[sailochanar]

Yeah I tried every possible approach u mentioned 

1. cell elements -data bars --->can only be set to row elements not for total value

2.I explored multiple visuals but results were not satisfying 

major difficulty is in tableau the tooltip doesnt define any specific thing :

whereas in PBI :

3.the slicer pattern I want to edit  instead circle slicing(roller)

@Ritaf1983 

[amitchandak · Accepted solution]

@sailochanar , I think Linear Gauge, might work better

https://appsource.microsoft.com/en-us/marketplace/apps?search=Linear%20Gauge%20&page=1

https://powerbi.microsoft.com/fr-fr/blog/visual-awesomeness-unlocked-gauges/