Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
If I had E.G a measure called [Total Sales] which was used on multiple visualizations on a page, is it possible that I would be able to turn off a drillthrough destination page for a certain visual so that they didn't all come up when drilling through, as its the same measure?
I have different formats of drillthrough pages for different visualizations and wanted just one drillthrough option to display for the user. The only way I can think of is by creating 5 Total Sales measures but this will completely clog up the report as I'm already using field parameters.
I've included an example below. As you can see there is a page for each drillthrough, with the measure in the drillthrough panes for all 3.
2) Measure on Page 2, 3 & 4.
Solved! Go to Solution.
instead of adding the measure to the drill through field, just add the dimension you're looking at the data with.
check this video https://youtu.be/2x9lLHDbtDk
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Hello @lherbert501 ,
If you want you could make the drill through based on the dimension that you're showing the sales with, like sales by country, so make the drill through by the coutry value.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
instead of adding the measure to the drill through field, just add the dimension you're looking at the data with.
check this video https://youtu.be/2x9lLHDbtDk
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
@lherbert501
It will stay show because of the salesperson, but this isn't a problem since its leading to the same result which is drilling by salesperson.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
I've duplicated the salesperson column and this has sorted it. Thanks for your help today @Idrissshatila
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |