Forum Discussion
Using Parameters on PBI desktop with a Live Connection to SSAS Tabular
You can use dummy table in cube, means let's say you want to take input from number, based on your requirement you can create one dummy table having one column with number series like 1 to 100 or anything.
Create table in model and don't make any relationship with that table.
Now use that column in slicer and write measure.
Let's say in your fact you have one measure and you want to display measure only if it is greater than selectedValue.
So create measure at power BI level/Cube level, it works fine in both condition.
Measure=if(Sum(Fact[amount])> Selectedvalue(Dummy[Series]),1,0)
Add measure in visual level filter and set measure is 1.
For data inputs as well you can create one data dummy table in cube and used it as slicer.
Calculated table as
Date Table =CALENDAR (DATE(2000;1;1); DATE(2025;12;31))
You can add different column in slicers and ask users to select value in slicer dropdown. It will work fine.
We are doing the same thing in our project.
Hi Anonymous ,
Thanks for the advice. Do you have a quick demo of this? Will the slicer have to be of pre-existing data in your tables?
Whatever data is there in your cube it will get reflected in your POWER BI file.
And one more think you can not create column or tables in Power BI if source is live connection. You to do all thing in Cube itself.
if it solves your problem please mark it as solution
Thanks for your input. The only issue with this method is that the data has to already be available/stored in the cube somewhere. What I need is a parameter where I can enter an arbitrary number such as '24', and I would want a measure on the page to filter the page based on the SELECTEDVALUE in the parameter box. Can such a thing be replicated via a live connection?
You can use dummy table in cube, means let's say you want to take input from number, based on your requirement you can create one dummy table having one column with number series like 1 to 100 or anything.
Create table in model and don't make any relationship with that table.
Now use that column in slicer and write measure.
Let's say in your fact you have one measure and you want to display measure only if it is greater than selectedValue.
So create measure at power BI level/Cube level, it works fine in both condition.
Measure=if(Sum(Fact[amount])> Selectedvalue(Dummy[Series]),1,0)
Add measure in visual level filter and set measure is 1.
For data inputs as well you can create one data dummy table in cube and used it as slicer.
Calculated table as
Date Table =CALENDAR (DATE(2000;1;1); DATE(2025;12;31))