How to create straight table for competitor by Revenue ?

[Paulyeo11]

Hi All

I have load the competitor data to PBI , But i am not able to create stairght table report to show competitor by Revenue amount.

my PBI file :-

https://www.dropbox.com/s/3b73fsffnmahvw0/COMPETITOR_V002.pbix?dl=0

[PhilipTreacy · Accepted solution]

Hi @Paulyeo11 

You've got a filter applied to only show values for the year 2020 and you don't have any data for 2020.  So the visuals were blank.

Remove the filter and you get this

regards

Phil

[Paulyeo11]

Hi Phil

Thank you very much for spot the filter.

Paul Yeo

[PhilipTreacy]

HI @Paulyeo11 

Sorry, just checked a bit more and realised that you have 100's  of blank rows in your data.  It just looked like there was nothing there.

You need to get rid of these blank rows and you will be able to do what you want.

To illustrate, after creating a new table with just a distinct list of Competitors

Table = FILTER (
    DISTINCT (
        SELECTCOLUMNS ( COMPETITOR, "COMPETITOR" , [COMPETITOR], "AMT REVENUE_C", [AMT REVENUE_C])
    ),
    NOT ( ISBLANK ([COMPETITOR] ) )
)

I can get this table visual.

Cheers

Phil

[Paulyeo11]

Hi Phil

Thank you for your help.

I try to delete all the empty row from my row data file .

But when i import to PBI , i still unable compute the striaght table for COMPETITOR AND AMT_REVUENUE_C

https://www.dropbox.com/s/5xt4q49cyzt1mok/COMPETITOR_V005.pbix?dl=0

I cannot use your script to delete to those empty row. because i need many field.

Paul Yeo

[PhilipTreacy]

Hi @Paulyeo11 

There's no data loaded into the model in that PBIX file?

Phil

[Paulyeo11]

Hi Phil

https://www.dropbox.com/s/5xt4q49cyzt1mok/COMPETITOR_V005.pbix?dl=0

from below screen shot , i have 16 row of data. 

I am not able create stright table for below 2 field :-

AMT_REVENUE_C

COMPETITOR

Notice that AMT_REVENUE_C field is whole number :-

[PhilipTreacy]

hi @Paulyeo11 

You've only highlghted 1 competitor?  Do you want to see a total for each competitor over a time period?  Or you want to see all competitors for all periods?  Can you please giev an example of your desired result?

Phil

[Paulyeo11]

Hi Philip

i just need to make the competitor sales amount display on straight table . 
I need to display all competitor sales . 

can you help me make the revenue amount display on table ?

paul