How to build a clustered column chart??

[Anmolgan]

I have a data which is having 3 users all belongs to differnet companies, each of the 3 users belong to 3 different companies each of the companies have different tables of them that contains sales on 2011,2012,2013 years, I want to plot a clustered column chart which will show one bar for total sales of all the companies on particular year lets say 2011, and other bar consists of total sales of each company on that particular year.

So far I am able to achive this but when I tried to use the sales columns (all aggregated of columns), I can see the aggregated value of total company on each year correctly but I am seeing total sales of companies on all particular years in case of other bars, how can I plot the data in such a way so that I can get total sales of each company on each year with comparison to total sales of all the companies on that particular year??

see both the graphs I want to plot them together.

[v-shex-msft]

HI @Anmolgan,

Please share us some sample data or pbix file for test, it is hard to clarify your scenario without any detail info.

In my opinion, if you tables has similar structure, I'd like to suggest merge them to one table with its name as tag column to mark original source table, then you can simply use one table to create visual.

Sample: Year as axis, company or user as legend, sale as value.

Regards,

Xiaoxin Sheng

[Anmolgan]

I know I can use one table to show the visuals but how can I show the total aggregates of all the companies in case of RLS, when one user logs in to see the comparison B/W its companies data and overal companies data?

[v-shex-msft]

Hi @Anmolgan,

#1. If your report not contains any sensitive data, you can upload to onedrive/google drive then share the link.

#2. It is impossible to view full source data and enabled RLS effect at same time.

AFAIK, RLS filter effect will works on data model level. So if you enabled RLS affect, these data will be filter by defined filter condition, it not means full source data.

In my opinion, I'd like to suggest you enter to query editor and create a table with summary records, remove relationships with other tables.(you can use it to view summarized original records in RLS mode)

Regards,

Xiaoxin Sheng

[Anmolgan]

Here is the link for the .pbix file

https://ifitech-my.sharepoint.com/:u:/g/personal/anmol_ganju_ifi_tech/EfJWIaCPD2FCkKwD_N3ZnwkBgynuTP...

[Anmolgan]

can sombody provide me an answer or any tips and tricks to achieve the objective??

[v-shex-msft]

Hi @Anmolgan,

Please refer to below sample.

Merged = UNION(Accenture,IFI,TATA,Sheet1) 

Regards,

Xiaoxin Sheng

[Anmolgan]

I appreciate the work you did, but I have seen the file it shows the overall sales of each company I want that the user form a particular company can see compare there sales from competetive companies, like if user A logs in he should see his companeis sales and in comparison to all of the companies sales. How can this be done??

[v-shex-msft · Accepted solution]

Hi,

You can consider to use RLS feature with username function.
For detailed information, please refer to below link:

RLS with UserName()

Regards,

Xiaoxin Sheng

[Anmolgan]

Hi

I am sharing my pbix file, you will see a clustered column chart that contains 4 bars, the one with light green contains the aggregated data of all the companies, other contains the data of different companies with different bars, what I want is if a user login (RLS), he will see his companies sale and also the aggregated sales of all the companies, How can i achieve this kind of scenerio???

How can I attach the .pbix file here???