cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Patryn999 Frequent Visitor
Frequent Visitor

Hidden visuals underlying data

Just a quick one - currently trying to have the slicers contolled externally/outside the iframe instead of in-app.

 

Got this working, but when I hide the slicer inside the iframe using custom layout then I can no longer get the data from this slicer to populate the external input - Just get an "Export data is not supported for this visual".

 

So does anyone know if this is possible, or otherwise if there's any way to get to and query to hypercube underneath to get this data from the report and then use report filtering?

 

Cheers,

Carl

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Bjarkiek Frequent Visitor
Frequent Visitor

Re: Hidden visuals underlying data

Hi,  I'm doing this by having it visible, but underneath another visual, or actually just under a white square.
If you figure out another way to do it, then I would be interested to know how.

 

2 REPLIES 2
Highlighted
Bjarkiek Frequent Visitor
Frequent Visitor

Re: Hidden visuals underlying data

Hi,  I'm doing this by having it visible, but underneath another visual, or actually just under a white square.
If you figure out another way to do it, then I would be interested to know how.

 

Patryn999 Frequent Visitor
Frequent Visitor

Re: Hidden visuals underlying data

For anyone coming in - this is the best method if you need to use the slicer relationships.

 

Identify your slicers by code, and use a custom layout option. Set the default state for all visuals to visible, and add in specific layout elements to push the slicers behind (i.e. set Z axis to -1). This way you can see and interact with slicers if opening pbix, but embedded the filters disappear behind the shape.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 6 members 936 guests
Please welcome our newest community members: