User Profile
harib
Post Patron
Joined 7 years ago
User Widgets
Contributions
How to show/hide buttons based on users
Hi Friends, I have senarios where we would like to Show and Hide buttons based on the users login. Ex : I have created 2 buttons like (Sales and Marketing) and we have users called User A, User B . When User A login, he should get only Sales Button, rest should not. Same way if User B login he should get only Marketing Button, rest should not. Is it possible to active it in Power BI. Thanks in Advance.Incremental Refresh with Limited Data
I have a data like 20 millions for 3 year. My requirment is , I would like to load 1 month data in the desktop for development and also needs to implement incremental refresh. I have a Date field like this (3/1/2018 12:00:00 AM) and I'm able create and define the parameters to that field. But only the thing is i would like to load 1 month data in the Desktop and reamining data would like to load in service. Is there any possibilities to achive this. Thanks in AdvanceHow to Pass Slicer selected Value into Calculated column to display the results
Hi All, I have create calculated column in Table A like below, however if i filter Date filed from the dimdate table, calculated column values are not changing. Ex : Calclulate Column = If(Table A[ Category] in {1,2,3} && NOT(Table A [Produts]) in {11,12,13}, [Total_Sales],BLANK()) Total_Sales is a Measure ( Total_sales=sum(Table B(Sales)) ) used in the calcualted column. Joins : Table A (ID) joined with Table B (ID) and Table B (Date) joined with Dim_Date (Date). Can anyone tel me, if we filter date in slicer, calcualted column should give the values accordingly. Thanks in Advance.Re: How to pass parameters based on filters and slicers
parry2k Thanks for the update. I have followed the steps which they mentioned and declared the parameter in advance editor. however where de we need to give the variable at source level.Colud you pls check and help me. let KustoParametersDeclareQuery = Text.Combine({"declare query_parameters(", "startTimep:datetime = datetime(", DateTime.ToText(StartTimeMParameter, "yyyy-MM-dd hh:mm"), "), " }), finalQuery = ({KustoParametersDeclareQuery}), Source = Oracle.Database("BDWDEV", [HierarchicalNavigation=true]), APP_PBI_RPT = Source{[Schema="APP_PBI_RPT"]}[Data], VW_TBQL4G97AMD1 = APP_PBI_RPT{[Name="VW_TBQL4G97AMD002"]}[Data] in VW_TBQL4G97AMD1 Thanks in advanceHow to pass parameters based on filters and slicers
Hi All, We have a below query to use in Power BI. We need to give a date prompt to the user where they can select the required dates . However we dont have calendar filed in the query , if we add calendar filed in the query it is missing its granularity . I would like to know can we pass parameters in the query level like paginated reports. select a11.ID, count(distinct a11.ACCOUNT_ID) from FACT_Tbl a11 join Dim_Tbl a12 on (a11.ID = a12.ID) join Date_Tbl a13 on (a11.DATE_ID = a13.DATE_ID) where ( and a13.CALENDAR_DATE between Add_months(trunc(sysdate, 'MM'), -1) and trunc(sysdate, 'DD') - 0) group by a11.ID My report got stuck here. If anyone know can u please send sample file. Thanks in advance.How to use numToDSInterval function in POWER BI
Hi Friends, I have a requirement where we need to implement the same logic in Power BI. Microstrategy they used numToDSInterval to get the date output like below image Formula being used in Microstrategy is : PROGRAM_AIR + numToDSInterval(a12.DURATION_MIN,'MINUTE') PROGRAM_AIR is date filed and DURATION_MIN is decimal number like (60,90,120,150....) We need a same output in POwer BI. Can you please let me know if anyone knows. Thanks in Advance
