Search found 8 matches

by okat
Wed Sep 20, 2017 11:20 pm
Forum: PowerPivot/DAX
Topic: Take the selected item in a slicer
Replies: 3
Views: 35

Take the selected item in a slicer

Is there a Dax function that allows me to take the selected item in a slicer?
Regards
by okat
Thu Aug 17, 2017 6:39 am
Forum: PowerPivot/DAX
Topic: Context Transition
Replies: 1
Views: 81

Context Transition

I have been practicing with the transfer of the filter context in Dax and I am asked the following question in relation to a measure: I have two tables: Sales and Calendar. I have implemented the following measure to calculate the sales of the previous year: 1- CALCULATE(SUM(Sales[Amount]); FILTER(A...
by okat
Wed Jul 05, 2017 9:47 am
Forum: Power BI Desktop/Service
Topic: Row Level Security
Replies: 1
Views: 187

Row Level Security

It is a company that has 70 vendors. Vendors can access a part of the report individually. Do I have to create a role for each salesperson? Is there another way to do it?
by okat
Fri Jun 16, 2017 12:25 pm
Forum: Power BI Desktop/Service
Topic: Power BI service does not update the dataset of a local Excel file
Replies: 1
Views: 196

Power BI service does not update the dataset of a local Excel file

I'm loading in the Power BI service in the cloud a dataset from a local Excel file http://bit.ly/2ttj0dk. I made a modification to the aforementioned Excel file, I basically added a new measure, but when I reload in the cloud, overwriting the data, the dataset does not reflect the changes made, alth...
by okat
Tue May 30, 2017 10:57 pm
Forum: Power BI Desktop/Service
Topic: Share reports with Power BI
Replies: 0
Views: 209

Share reports with Power BI

I am a free power bi user, with the modifications that Microsoft has implemented, as I do to share my reports with clients?
Regards,
by okat
Tue Apr 18, 2017 12:53 pm
Forum: PowerPivot/DAX
Topic: Building a spinner with slicers
Replies: 2
Views: 295

Re: Building a spinner with slicers

Thank You Matt. Someone wanted to implement this but using Power BI.
by okat
Tue Apr 18, 2017 6:00 am
Forum: PowerPivot/DAX
Topic: Building a spinner with slicers
Replies: 2
Views: 295

Building a spinner with slicers

I would like know if you can build a spinner, same style as in excel, with slicers to vary from 0 to 100. I would like to apply it as a percentage that varies according to the selection made.
Regards.
by okat
Tue Apr 18, 2017 4:44 am
Forum: Power Query
Topic: Difference between years
Replies: 1
Views: 326

Difference between years

I have an annual series of data over a period of 10 years and I would like to know the differences from one year to another. How could you implement this in power query?
Regards.

Go to advanced search