Custom tooltip for table with measures - sorting columns

[Now92Jah]

Hi, 

I have a table with data about sale of products sliced with month/year. 

The results were calculated using measures, different for each product. 

I also needed to add tooltip showing sale per client per product - it required from me to build custom tooltip&measure. 

I used those solutions: 

Solved: Re: Custom Tooltip on Matrix Based on Measure - Microsoft Power BI Community
Solved: Can I have a tooltip per entry to a table? - Microsoft Power BI Community


It worked perfectly. The only problem is that I have columns in alphabetical order, whereas I need them to put in my own order. 

Is there a way to do that? 
The only way I found is to ad letters in headers, like A. B. C. - but it is not an elegant solution. 

Thanks for help

[v-angzheng-msft]

Hi, @Now92Jah 

May I ask if your problem has been solved? Is the above post helpful to you?

If  it does, could you please mark the post which help as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.😀

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-angzheng-msft · Accepted solution]

Hi, @Now92Jah 

Your matrix data also seems to come from another table. Note that you need to sort the column fields in the matrix. Click on the column field of the matrix to sort by the sorting column. Instead of sorting the column fields summarized to another table.

To make it easier to understand, I created an Sample

Please refer to the attachment below for details. Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-angzheng-msft]

Hi, @Now92Jah 

Do you need to create a tooltip for a matrix and then sort the columns of the matrix?
If so, you can create a sorted table, use the RELATED function to add a sorting column to the main table after establishing a relationship with the main table, and finally sort the target column according to the sorting column.

You can check this thread for more details

sort months into chronological order

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Now92Jah]

Hi @v-angzheng-msft , 

Tried this solution - did not worked out. Maybe because it is used with the table which function is to be the headhers of a matrix, therefore it has only unique values? 
Relation:

Headers of the key table:

Supporting sorting table: 

My final table, which needs to be sorted in my order (sorry for that, my model is to big to create sample data): 

Any ideas, what can I do? 

[lbendlin]

assuming your tooltip is fed by a report page you should be able to add another tooltip to the visual on that page, and then sort by that.