Consider this scenario:
We have two reports:
- One indicating online sales data later, and compared to the previous year
- One indicating the retail sales data later, and compared to the previous year
We have one details page, which works as a drill-through targeted in both pages, indicates detailed information on sales.
The question now is: How do we know which page from the page from the food passing out?
Here is how we can build a solution to a moving theme on the drill-using page that shows a page from the page.
Preparing for a data model
The first step is to keep the information about the applicable page right before making a drill-acting action.
Unfortunately, DAX does not have a job to find the name of the current page.
Therefore, he should build a custom solution.
The first step is to create a table with the names of all the pages in the report.
I do this with “enter data”.
There I built this table:
Here, I have to enter every page of the report, can be a page from drill-through action.
Note that the words are included in the table to be displayed on the gambling page. Therefore, we enter the meaning of purpose, which we can not turn into words buttons.
The next step is to create an average of the current value:
Source Page = SELECTEDVALUE('Report Pages'[PageName])That's all preparing this solution.
Set up pages report
Next, we must add the filter to each of the two pages, which put the page name:
We do this in both pages with the name of the corresponding page.
On the drill-page page, we place “Save all filters” prepared:
This preparation must be activated to ensure that the remedy works as expected.
The reason for commenting on “On” that the filter is added to the source page must be transferred to the driver page. I can see the amount in DAX only this way.
This looks like in the drill-on page:
But I had situations where the set could make unwanted results. For example, when the drit-on-drit-on-Distrill page is proven to be affected by sorting on the source page or visible source. This is not a normal state, but it is possible.
However, adding column Pagename such as a drill colon – through unless visible source and put this column. Adding this column to Visual is not reasonable, because there is no contact or mentioned with the database.
Therefore, this is the only purpose of passing the Source page in drill-page.
I don't know another way to solve this challenge.
Does it work?
Now, let's add a picture to the driving page in the box and enter steps made before the amount.
After driving a verb from the sales page, it looks like:
Based on this effect, we can create an estimate of the topic or text below, including this amount.
That is all we need to do to finish the solution.
Issues
This is a specific solution to find information about the page from the page.
However, with two problems:
- As soon as I enter the New Reports page, which can work as a drill-paper pulling page, I have to remember to add a new page name to “Report Pages”.
- This will not work when planning to have a second driver-free level.
In the second issue, as soon as you plan to jump to another gambling page from first, you should add continuous performance.
For example, a different table or other column in “Report Pages”.
You should choose the method in accordance with you planning something like Breadcrumbic text, allowing the user to see all the way, from the first place on the second source page.
Let's see why this is needed:
For example, you enter a new line in “report pages to the first page of the name of the page” page name “page details”.
Then, you add a page filter on the drill-page page, specify the drill name-through the name of the page.
The result behind a drill-acting of the first action will be:
- The blue filter is the person who puts the PageName to “Details Page”.
- The green-marked filter is the person that is a drill-through action-through and set to “Retail Sales”.
We have two filters now, written, leading to empty outfits. The result is – The table with both sorts, but conflicting filters.
For this reason, we cannot use the concatenateex () to find both prices.
Therefore, we need additional column on the reported pages table, which is used in this situation, or a different table of pages.
Here's the way with additional column:
The name of the Column SubpagName contains the name of the page (s) that can be accessed on the source page.
After adding a page filter to a subpagName and add new rating of the SubpagName column, I get this outcome:
Combining these two steps in one step of the topics can create a breadcrum path that can be displayed on the second gambling page:
Average used is simply a secret text and two measurements:
Sub Page Breadcrumb = "Drill-Through mavigation from: " & [Source Page] & " - " & [Source Sub Page]Store
Now that I have given you the tools needed, you can create your solution to track the names of the page from driving.
It's definitely noticing. However, you should know the technological needs and the bad consequences.
Once you know yourself well, you can use them in all reports.
I wish you much success about it.
Progress
As my previous topics, I use the Coco sample data. You can download Contosoretailw Dataset free from Microsoft here.
Coco data can be used freely under the MIT license, as described in this document. I changed the dataset and delete information in modern days.
