Transfer same column in tabe to make customer map

[Anonymous]

Hello,

i have to do a map of all customers on 1 page, company have around 100-150 customers(stores) daily in the report. 

Idea is to choose 1 store and drill-trough to another page with another data, also i will make conditional formating on other data after i decide good visialization, so each store will have special color base on it's status

I tried with the TreeMap but i don't like that some rectangles have different size. I know that it's not normal to use treemap for solution like that, but when I try to use table visualisation i have a lot of empty space and don't know how to transfer column ID_CLIENT to have more than 1 column in table.

Could you please give an advice how to do that?

[v-diye-msft]

Hi @Anonymous 

What about the custom visual: 

There's no scroll down , instead there's pagination:

[Anonymous]

@v-diye-msft  thanks for proposal, I need to fill all the free space with ID_CLIENT values, without pagination or scrolling

[amitchandak]

@Anonymous , with Store use count of the store and try a heat map

If store Id of add  index column

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

The create column like given below . Use a big font and display MAx(Store[Name]) by putting these in row and columns of Matrix. you can change 10 based on fitment

columns  = Mod([Index],10)

row  = Quotient ([Index],10)

[Anonymous]

@amitchandak ,

i just added rownum in my oracle query and call it index, it just count each row in the query (look like index)

But when i add formula as you propose - i have an error like below:

 

[Anonymous]

@amitchandak  hello, couldn't test right now, my query works in directquery mode and i can't add index. I can't modify query also, because my DBA is on vacation for the moment

do you see other solutuions?

[Anonymous]

Thank you, i will try to do it and comeback with answer