Forum Discussion
Word Cloud - Top N and Invert Size
Hello,
I have a question regarding "Word Cloud" custom visual. Let's say in my table, I have a column for "Keyword", "Cost" and "Clicks". I then create the following measures:
[Total Cost] = SUM(Table[Cost]) [Total Clicks] = SUM(Table[Clicks]) [CPC] = DIVIDE([Total Cost], [Total Clicks]) // Cost-per-click
I then add the Table[Keyword] in the "Category" section of Word Cloud visual, and add [CPC] in the "Values" section. All works fine, I see the keywords and size of the keyword is based on [CPC]. Bigger the CPC, bigger the size of the word and vice versa.
Questions:
- I want the size word to be inversely proportional to [CPC] i.e. smaller the CPC, bigger the size of the word.
- I could multiply the [CPC] by -1, this will solve the above problem but then the Tooltip shows negative CPC which doesn't make sense and confusing for the end user.
- Let's say I have 1000s of keywords in my Table. But I only want to show Top 20 keywords based on the CPC, making sure above point(point 1) holds true.
Any ideas?
Thanks,
Shiv
Hi shivkonar,
Questions:
- I want the size word to be inversely proportional to [CPC] i.e. smaller the CPC, bigger the size of the word.
- I could multiply the [CPC] by -1, this will solve the above problem but then the Tooltip shows negative CPC which doesn't make sense and confusing for the end user.
- Let's say I have 1000s of keywords in my Table. But I only want to show Top 20 keywords based on the CPC, making sure above point(point 1) holds true.
1. As Report tooltip page is not supported for custom visuals, I'm afraid there is no better way for us to solved this.You also could have a consult for Power BI custom visual community to get more professional help about this custom visual.
2. If you want to show the Top 20 keywords based on the CPC, you could create calculated columns or measures with RANKX or TOPN functions.
For about how to use RANKX, you could have a reference of this bolg.
Best Regards,
Cherry
- I want the size word to be inversely proportional to [CPC] i.e. smaller the CPC, bigger the size of the word.
1 Reply
- v-piga-msft
Resident Rockstar
Hi shivkonar,
Questions:
- I want the size word to be inversely proportional to [CPC] i.e. smaller the CPC, bigger the size of the word.
- I could multiply the [CPC] by -1, this will solve the above problem but then the Tooltip shows negative CPC which doesn't make sense and confusing for the end user.
- Let's say I have 1000s of keywords in my Table. But I only want to show Top 20 keywords based on the CPC, making sure above point(point 1) holds true.
1. As Report tooltip page is not supported for custom visuals, I'm afraid there is no better way for us to solved this.You also could have a consult for Power BI custom visual community to get more professional help about this custom visual.
2. If you want to show the Top 20 keywords based on the CPC, you could create calculated columns or measures with RANKX or TOPN functions.
For about how to use RANKX, you could have a reference of this bolg.
Best Regards,
Cherry
- I want the size word to be inversely proportional to [CPC] i.e. smaller the CPC, bigger the size of the word.