Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

help on chart web traffic

hi all, I have a website and it running on a campaign for 1 month.. Is there a way to show during this month, what time is the highest traffic? Attached is the sample file, is there a better way t...
Need Help
v-joesh-msft's avatar
v-joesh-msft
Icon for Solution Sage rankSolution Sage
6 years ago

Hi Anonymous ,

You can try the following method:
1. Create the following measure Rank:

Rank = RANKX(ALL(Sheet1[Hour]),CALCULATE(SUM(Sheet1[View])),,,Dense)

2. Apply Rank to the filter and set the value of Rank equal to 1:

Here is a demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EWQduaFvIhZBi7XG_mRR6skBe289p2kQ12t85e6pv-c-Fw?e=WckJRm

Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hihi...is there a way to show as a card visual or chart instead of table?

    I tried but doesnt seem working.

    Thanks so much