Forum Discussion

mateoc15's avatar
mateoc15
Advocate II
2 years ago
Solved

Creating a ribbon chart with non-date X axis

Hello.  I have a data set of web pages visited by a user.  I'm analyzing how users get to the search page and where they go from there.  There is no date involved, and all I have seen in tutorials is...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi,mateoc15 

    Thank you for your reply.

    I apologize for not understanding your needs and providing the wrong answer.

    Based on your latest description, I've created the following test, which hopefully meets your expectations

    C_result = 
SWITCH(TRUE(),
'case04'[Page Name]="Search Results","Search Results",
CONTAINSSTRINGEXACT('case04'[Referring Page Name],"Search Results"),"Destination Page",
"Source Page"
)

    Please let me know if I give a response that does not meet your expectations.
    Looking forward to your reply.

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

    Best Regards,

    Carson Jian,

    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
2 years ago

Hi,mateoc15 
I am glad to help you.

According to your description, you want to create a new calculate column (the value is the type of the current user action: Source Page, Search Results, Destination Page) created on the basis of the user actions recognized in the table table.

Here are some of my suggestions, hopefully this will give you some ideas

For example, in the Referring Page Name column, if there is a website url, it will be recognized as a Source Page.

This requires the ability to recognize the website link in the Referring Page Name column, such as the keyword “.com”.

 

Here's a test I ran to see if it meets your expectations (defining the type of behavior by identifying the keyword in the Referring Page Name)

Here is my question for you to give a suitable answer

In fact the advice I gave above is very narrow, (only suitable for only a few kinds of website links) Is your real environment in the Referring Page Name column are some website links, is the full link for example https://app.powerbi.com Or is it part of the link e.g.

Mysite.com (without the Https prefix), which is where you give the test data
If you have a very large variety of URLs, I would recommend that you do the text field recognition in Power Query to create new columns, rather than using DAX code (if I understand your requirements correctly), as this is very inefficient.

Can you give me a more detailed test case, (without your real sensitive data), where you just need to provide the format of the recognized fields, by linking to some non-sensitive websites like https://app.powerbi.com。
If you can provide a pbix file that does not contain sensitive data, that would be helpful in resolving your issue!

Here are other resolved issues I found that may help you, hopefully it will help
URL:Solved: Column to URL in POwer Query - Microsoft Fabric Community

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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

mateoc15's avatar
mateoc15
Advocate II
2 years ago

Thank you for your reply!  First, I don't have an issue specifically with URLs - https and such.  The problem is that I want three items on the X axis - Source Page (many URLs), Search Page (there will only be ONE value like .com/search-results), and Destination Page (many URLs).  The output will look something like...

I intend to do just a Top N URLs so there aren't hundreds of items on the left and right.  I know that would be insane.
The data is structured in such a way that I only have the page name, and the page that referred the visitor to the page.  The search results page can actually be either the page name, or can also be the destination page as well.  Basic logic:

  • Page name is Search Results AND referring page name IS X, that's a SEARCH RESULTS page
  • Page name is X, AND referring page name is Search Results, that's a DESTINATION page
  • Page name is X, AND referring page name is NOT Search Results, that's a SOURCE Page

For the sake of simplicity I've just used page names instead of URLs, but the idea is the same.
The other post you shared didn't help unfortunately.  It's unrelated to the ribbon specifically.
Does this help clarify?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,mateoc15 

    Thank you for your reply.

    I apologize for not understanding your needs and providing the wrong answer.

    Based on your latest description, I've created the following test, which hopefully meets your expectations

    C_result = 
SWITCH(TRUE(),
'case04'[Page Name]="Search Results","Search Results",
CONTAINSSTRINGEXACT('case04'[Referring Page Name],"Search Results"),"Destination Page",
"Source Page"
)

    Please let me know if I give a response that does not meet your expectations.
    Looking forward to your reply.

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

    Best Regards,

    Carson Jian,

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