Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)
recategorized by

How can I create a word cloud for custom visuals, For example, I am having in my table a column for "Keyword", "Cost" and "Clicks" and created a measure

[Total Cost] = SUM(Table[Cost])
[Total Clicks] = SUM(Table[Clicks])
[CPC] = DIVIDE([Total Cost], [Total Clicks]) // Cost-per-click

I want to display top 20 keywords based upon on cpc

1 Answer

0 votes
by (22.5k points)
edited by

Define a measure which is reciprocal of [CPC]

Size = DIVIDE(1, [CPC])

To get TOP N filters use keyword-based on [Size] measure

Top N Filtering

I recommend this Power BI course by Intellipaat to learn Power BI.

Related questions

0 votes
1 answer
asked Apr 6, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
asked Jan 21, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
asked Dec 22, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
asked Jan 6, 2021 in BI by Chris (11.1k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...