rajcha Tracker

A visual which displays comparison of different categories but displays only the name of logged in user

rajcha — Sat, 26 Aug 2017 01:59:00 GMT

Hi. I have a requirement where in I have managers and employees under them. I would like to use a funnel chart which shows number of employees for each manager. Now my requirement is to hide the manager name on the bar and just show the number of employees on each bar of the funnel chart. I also want to show the just name of the manager who logs in. That way he can see where he stands on the count of employees under him compared to the other managers, but he will not be able to see the names of the other managers. It will serve the purpose even if I am able to highlight the bar in the chart corresponding to the manager who logs in, may be with a different color. It would be great if you can suggest if there is any other chart also which will serve the purpose.

funnel chart

rajcha — Wed, 23 Aug 2017 13:55:19 GMT

It will serve the purpose even if I am able to highlight the bar in the chart corresponding to the manager who logs in, may be with a different color.

It would be great if you can suggest if there is any other chart also which will serve the purpose.

Thanks.

Re: How to give 2 or more data sources in blank query

rajcha — Mon, 24 Oct 2016 19:24:00 GMT

I have to use temp tables in my query. So writing a query is unavoidable in my case.

How to give 2 or more data sources in blank query

rajcha — Mon, 24 Oct 2016 18:41:31 GMT

I have a requirement where I have to join two tables from two different data sources. I have selected the blank query option and I am writing the query in the advanced editor option available in the query editor. This advanced editor allows me to enter only one data source. Is there a way where I can give two or more data sources.

The below works.

let

Source = Sql.Database("servername", "datasource1",

[Query="SELECT BusinessEntityID, FirstName, MiddleName, LastName,

JobTitle, City, StateProvinceName, CountryRegionName, TerritoryName,

TerritoryGroup, SalesYTD, SalesLastYear

FROM Sales.vSalesPerson;"])

Source

"datasource1" is one data source.

My question is how to add another datasource.

Thanks.