Forum Discussion
Transfer same column in tabe to make customer map
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?
6 Replies
- amitchandak
Super User
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)
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?
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:
- v-diye-msft
Community Support
Hi Anonymous
What about the custom visual:
There's no scroll down , instead there's pagination:
v-diye-msft thanks for proposal, I need to fill all the free space with ID_CLIENT values, without pagination or scrolling
