cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
Memorable Member
Memorable Member

You have implemented Row Level Security to restrict users to view data accordingly but you want to create a dynamic Admin role that can be assigned to any user to view all data and at the same time, you do not want to assign Admin permission to the user.

Read more...

Super User II

Learn the logical processing order of Power BI from Get Data to Report. If you don't understand why a slicer selection doesn't update your calculated column or you're trying to refresh the report to recalculate, this post might help shed some light on how Power BI thinks.ExcelwithAllison.com 

Read more...

Microsoft
Microsoft

Use the UNICHAR function and Unicode to create visuals.

Read more...

Super User II
Super User II

Every tool has got it's own way to create and manage work-arounds based on the different requirements.

Today in this blog, I will be showing how one can implement a functionality, where the default view of a visual is required to be a custom message until the user makes a selection from the slicer.

Read more...

Solution Sage
Solution Sage

Some times, even after applying Page / Report Level Filters, we may require few visuals should not interact with that Filter and they should stay Standalone.

Read more...

Microsoft
Microsoft

Memory/CPU is utilized for Paginated Report even though you do not have a Paginated Report 

 

 

Read more...

Microsoft
Microsoft

Unable to connect to IBM DB2 from PBI Desktop

Error:

  • IBM DB2: ERROR [42704] [IBM][DB2]SQL1234 "SYSCAT.SCHEMATA: is an undefined name."
Read more...

Microsoft
Microsoft

Let's learn how to fetch the Count of products in a given date range between the Start and End Date Ranges.

Read more...

Super User I
Super User I

Format your DAX expression in a post like this:

Measure Cumulative =
CALCULATE (
    [Measure],
    FILTER (
        ALLSELECTED ( 'Date'[Date] ),
        ISONORAFTER ( 'Date'[Date], MAX ( 'Date'[Date] )DESC )
    )
)

 

Read more...

Super User II
Super User II

Power BI has got an amazing functionality to change the hierarchy of the hierarchical data using DRILL-DOWN and DRILL-UP icons provided on the visuals.

We can create a different view for the similar functionality which may look better from user's perspective.

In my following article, I will take you through the steps of creating a drill-action on the hierarchical data by using Bookmarks.

Read more...

Microsoft
Microsoft

A new feature has been released for Dataflows which allows us to assign different Azure Data Lake Storage to different workspaces (at the workspace level settings)without using the Power BI tenant level settings. However, while trying to assign a Data Lake Storage to a workspace I got an access denied error message, on a recent in-house repro.

Read more...

Microsoft
Microsoft

We couldn't connect to model in Power Bl Service. The dataset may have been deleted, renamed or it is possible that don't have permission to it.No OLE DB Error Information found.

Read more...

Memorable Member
Memorable Member

Customers ask you to show total values in a bar-chart for all years along with each year individually.

 

FarhanAhmed_0-1601358870005.png

Read more...

Super User II
Super User II

Power BI already gives us a way of applying conditional formatting on the table and matrix visuals using the default settings.

Suppose I need to give some custom color-based formatting to my cells in a table visual, how will I achieve this?

There is an easy way to create custom color formattings in Power BI using a simple measure calculation. In this article I will walk you through a step-by-step example on how to implement this in Power BI.

Read more...

Super User II
Super User II

WordCloud custom visual in Power BI gives a great way to visualize the most occurring words in the data. The size of the word depends on how frequently it appeared in the data-set. One can limit the number of words to be displayed in WordCloud. The defualt setting displays 200 words in this visual.

But, have we ever thought of modifying this word limit without changing the underlying word-limit setting in the visual. Basically creating a slicer in the report and then changing the number of words to be displayed in the WordCloud.

This article here gives a workaround on how one can achieve this functionality in Power BI.

Read more...

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.