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 ...
amitchandak
Super User
Super UserAnonymous , 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?