How to use filter
-
Hi
Thanks for making this plugin. I’ve been using it for a while now and it’s perfect. But recently I need to use filter to filter my page based on some parameters but I can’t figure out where to insert this javascript code in the samples:var relatedFilterObj = [{
$schema : “http://powerbi.com/product/schema#basic”,
target : {
table : “Countries”,
column : “Country”,
},
operator : “=”,
values : [country]}
];var relatedURL = pageURL + “?filters=” + encodeURIComponent(JSON.stringify(relatedFilterObj));<h3>Applying Slicers</h3>The plugin can also apply Slicers before the report loads based on passing stringified JSON in the URL. Read more about [Slicers](https://github.com/Microsoft/PowerBI-JavaScript/wiki/Slicers)
Thanks
Zara
-
Hi
I managed to do it:
In my application I get the userid of the logged in user and pass it to my power bi report to filter the results. I keep the useid in user’s display name in WordPress.I use XYZ PHP Code plugin to add php code to my pages.
I added this code to a page(using XYZ PHP Code) and create the link to view the reports on the fly:<?php
$current_user = wp_get_current_user();
?><script type=”text/javascript”>
var tnum= “<?php echo $current_user->display_name ?>”;
var relatedFilterObj = [{
$schema : “http://powerbi.com/product/schema#basic”,
target : {
table : “the table name in your dataset”,
column : “T Number”,
},
operator : “=”,
values : [tnum]}
];</script>
<b>
“<“ul”>”“<“li”>”
“<“a href=”http://YourWordpressSiteName/ReportPage/”>View Report</a”>”
“<“/li”>”“<“/ul”>”
</b>In your report page simply embed the power bi report:
[powerbi id=”id” width=”100%” height=”1080px”]Please let me know if it helps.
Zara
The topic ‘How to use filter’ is closed to new replies.
